calculating seconds in excel..please help
 

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?

calculating seconds in excel..please help
 

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

"longy" wrote:

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?

calculating seconds in excel..please help
 

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).

"longy" wrote:

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?

calculating seconds in excel..please help
 

"longy" wrote in message
...
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?

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 [s], 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).
--
David Biddulph