Times are stored as fractions of a day. To convert seconds to a time, divide
by the number of seconds in a day:

=357646/24/60/60, format as time/date

To get the difference between two dates/times, just subtract them:

=b1-a1, format as date/time

Excel doesn't handle negative times well, so make sure you subtract the
earlier from the later date.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Samantha" wrote in message
...
Does anyone know how to convert 357646 seconds into d/hh:mm:ss format.
ALso does anyone know how to find the different between date and time. e.g
different between 01/02/2005 10:50:14 and 02/02/2005 16:47:08?