Thankyou- I understand

Cheers


"Arvi Laanemets" wrote:

Hi


"James" wrote in message
...
Arvi,

Thanks for that - 1 last thing can you explain how this formula works, ie;

are you multiplying 24 hrs by 60 mins by 60 secs then dividing by the
number of seconds in cell A2?

Exctly that.

Date and time in Excel are really both same data type, a datetime. The date
is integer part od datetime, and time is decimal part. One day is really a
number 1. You had the number of seconds in cell, dividing it with 60 give
number of minutes, dividing again gives number of hours, and at last
dividing with 24 gives number of days (in your case it is
0.0424305555555556, which in time format is displayed as 01:01:06).

PS. I used (24*60*60) in formula to make it easier to understand. You can
replace it with 86400.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets