Formula to calculate time
I couldn't duplicate that behavior in xl2003. In tools
=Options=Transition, do you have anything selected in the checkboxes on
that dialog. If so, try unchecking them.
--
Regards,
Tom Ogilvy
"accelerator" wrote in message
oups.com...
I also noticed, that although I set the format to UTC (e.g. 13:30),
when I enter 12:00 it assumes that it is midnight and not mid-day.
When I enter 12:00 it displays 0:00!
|