Converting HH:MM:SS to seconds

Question

Hi all,&nbsp;I am currently trying to convert values which have HH:MM:SS time values to the number of seconds.&nbsp;&nbsp;I hope someone can point me into the right direction.&nbsp;Best regards,LMeijdam

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;-If the column has a Time datatype (preferable), you can do this:Seconds Since Midnight = [Time Datatype]*86400If it's text, you need to convert it to time first:Seconds Since Midnight = TIMEVALUE([Text Datatype])*86400Cheers!Nathan

Forum Discussion

Converting HH:MM:SS to seconds

2 Replies

Related content

How to convert seconds to hh:mm:ss

How to convert seconds to hh:mm:ss

Convert HH:MM:SS to seconds

Convert seconds to HH:MM:SS then SUM

Converting seconds into HH:MM:SS