Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 )