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?