I understood the OP asked two separate questions:
(1) what is 357646 in date/time format, and
(2) how do you subtract 01/02/2005 10:50:14 from 02/02/2005 16:47:08

An Excel date field can contain both a date and a time. Date fields are the
number of days since January 1, 1900, and can contain fractions. The
fraction portion is the time of day (eg, .25 is 6:00 am because it's
one-quarter of the way through the day).

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


"Littlebird" wrote in message
...
Is the answer 20:46:0 ? That is what I get.
How can you use date when you don't have a date in the question ?

"Samantha" wrote:

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?