Excel 2003 and Time Formats

[Mike]

So, I just upgrade my OS to Windows 7. I have a spreadsheet that does time
calculations from time to hours. It has worked flawlessly for years, and
even for the first day I had Windows 7... in the same spreadsheet. Now it
doesn't seem to recognize the 12:00 AM format and it's being interpreted as
text, not time anymore. When I reformat the cell so that it's a new time
format, it's not interpreting any of them anymore....

Is anybody else having this problem? Have you heard/seen this before?

 

[Mike]

Okay, I figured it out... apparently you can't change your OS date time
settings/format without it effecting excels calculations. I had changed it
so the date on my task bar would show the day of the week too... so when I
changed the global format for date/time it came through right again.

 

[Bernard Liengme]

I doubt this has anything to do with Win 7 - just a coincidence.
Us Clear All on the cell and reenter 12:00 AM
IF this is cell A1, in another cell enter =A1+2/24 to see if you get 2:00 AM
best wishes