"
"Dave" wrote in message
...
Hi Sandy,
Thanks for pointing that out. So I tried entering zero into a cell with
date
format, and got 00-Jan-00. So that explains the month=1 bit, but the
zeroth
of January???
Dave.
Yes it is strange. One minute past midnight on January 1st, (ie 1/1/1900
00:1 ), is 1.000694444 so everything under 1 must be in some sort of cyber
time. Mind you that is where the *normal* times that you enter, (like
08:00) reside. Enter 08:00 four cells and then sum them in a cell formatted
as dd/mm/yyyy hh:mm. You will get 01/01/1900 08:00. So where were the
first three sets of eight hours? <g
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk