calculating seconds in excel..please help

L

longy

I have a list of times,at the end of the column i add the total.I then need
to work out how many seconds in the total.,for example 10:59:01 is the total
time - whats the formula to translate this total into seconds please?
 
B

bpeltzer

You could just format the result (format > cells, select the Number tab,
choose a Custom category and set the format to ).
Or multiply the result by 86400 (the number of seconds in a day) and format
the result as a normal number.
 
P

Paul Mathews

A couple of approaches (assume A1 = time 1, A2 = time 2):

1. (A2-A1)*24*60*60, format the resultant cell as general

2. (A2-A1), format the resultant cell as "[h]:mm:ss" if you want potential
hours, minutes and seconds or "mm:ss" for minutes and seconds, or "ss" for
just seconds (assuming you know the difference will always be less than 60
seconds).
 
D

David Biddulph

longy said:
I have a list of times,at the end of the column i add the total.I then need
to work out how many seconds in the total.,for example 10:59:01 is the
total
time - whats the formula to translate this total into seconds please?
Click to expand...

Two ways. If the data is in Excel time code (fractions of a day), you can
just format it in seconds, i.e. format code , or if you want to convert
it to a number of seconds you can convert from days to seconds by using the
formula =A1*24*3600 (and format as General or as a number).
 
Top