cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vkandala Frequent Visitor
Frequent Visitor

Convert run_duration (DD:HH:MM:SS) column to Seconds

Hello,

 

I am trying to convert run_duration (DD: HH: MM: SS)  column to Seconds. 

For example, if Run duration is 1 Day: 1 hour: 1 minute: 1 second I need to convert it to 90061 seconds

 

86400 + 3600 + 60 + 1 = 90061.

 

 

Thanks

1 REPLY 1
bapt69 Member
Member

Re: Convert run_duration (DD:HH:MM:SS) column to Seconds

Hi,

i don't know if it's the good part of the forum...anyway

 

=DAY([Date])*8640+HOUR([Date])*360+MINUTE([Date])*60+SECOND([Date])

 

Does it work?