How can I convery time?

[Guest]

I have a column full of time in the format hh:mm:ss so and entry could be
00:23:03 for 23 minutes and 3 seconds.

How can I get the total number of seconds for an entry?

 

[Guest]

If you simply want to display the total number of seconds use a custom number
format of...


If you want a formula to show the number of seconds use this formula
=A1*24*60*60
You will have to change the format to a number (otherwise it will think the
result is a date).

 

[Guest]

Sloth,

That was great. After I posted the question I tried to work out a formula.
I got one that worked but is was:

=CONVERT(HOUR(A2),"hr","sec")+CONVERT(MINUTE(A2),"mn","sec")+SECOND(A2)

As you can guess I much prefer your suggestion.

Thanks for your help

Keith

If you simply want to display the total number of seconds use a custom number
format of...


If you want a formula to show the number of seconds use this formula
=A1*24*60*60
You will have to change the format to a number (otherwise it will think the
result is a date).

I have a column full of time in the format hh:mm:ss so and entry could be
00:23:03 for 23 minutes and 3 seconds.

How can I get the total number of seconds for an entry?