"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