Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one field named "Duration" which contains the time values in HH:MM:SS format (like 00:12:36). I want to convet these values in Seconds. Please suggest me.
Thanks.
Hi
Do you want to format it to display seconds (assuming Duration is a valid time value?
=Interval(Duration, 'ss')
Or assuming it is a string?
=Interval(Time#(Duration), 'HH:MM:SS'), 'ss')
Or do you want to convert it to seconds (assuming it is a valid time value)
=Duration * 86400
Or convert it (assuming it is a string)
=Time#(Duration, 'HH:MM:SS') * 86400
HTH
Jonathan
hi
try this
=Interval(Time#('00:12:36','hh:mm:ss'),'ss')
For Seconds =Interval(Time#('00:12:36','hh:mm:ss'),'ss')
Hi
Do you want to format it to display seconds (assuming Duration is a valid time value?
=Interval(Duration, 'ss')
Or assuming it is a string?
=Interval(Time#(Duration), 'HH:MM:SS'), 'ss')
Or do you want to convert it to seconds (assuming it is a valid time value)
=Duration * 86400
Or convert it (assuming it is a string)
=Time#(Duration, 'HH:MM:SS') * 86400
HTH
Jonathan