Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Convert Time from Text to HH:MM:SS as integer

Hi Experts

 

How can i convert the following from a Text Calculated Column to a Integer so i can sum the total time. 

 

HH:MM:SS = 
RIGHT ( "0" & INT ( vw_fct_irs_time_taken[Time Taken in seconds] / 3600 ), 2 )
    & ":"
    & RIGHT (
        "0"
            & INT ( ( vw_fct_irs_time_taken[Time Taken in seconds] - INT (vw_fct_irs_time_taken[Time Taken in seconds] / 3600) * 3600) / 60 ),
        2
    )
    & ":"
    & RIGHT ( "0" & MOD (vw_fct_irs_time_taken[Time Taken in seconds], 60 ), 2 )

 

1 REPLY 1

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.