cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
LMeijdam Established Member
Established Member

Converting HH:MM:SS to seconds

Hi all,

 

I am currently trying to convert values which have HH:MMSmiley FrustratedS time values to the number of seconds. 

 

I hope someone can point me into the right direction.

 

Best regards,

LMeijdam

1 ACCEPTED SOLUTION

Accepted Solutions
natelpeterson New Contributor
New Contributor

Re: Converting HH:MM:SS to seconds

Hi @LMeijdam -

If the column has a Time datatype (preferable), you can do this:

Seconds Since Midnight = [Time Datatype]*86400

If it's text, you need to convert it to time first:

Seconds Since Midnight = TIMEVALUE([Text Datatype])*86400

Cheers!

Nathan

2 REPLIES 2
natelpeterson New Contributor
New Contributor

Re: Converting HH:MM:SS to seconds

Hi @LMeijdam -

If the column has a Time datatype (preferable), you can do this:

Seconds Since Midnight = [Time Datatype]*86400

If it's text, you need to convert it to time first:

Seconds Since Midnight = TIMEVALUE([Text Datatype])*86400

Cheers!

Nathan

LMeijdam Established Member
Established Member

Re: Converting HH:MM:SS to seconds

Hi @natelpeterson ,

 

Thanks this seems to work Smiley Happy

 

Enjoy your weekend!

LMeijdam