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
Sloth said:
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).
Keith said:
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?
