Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 and Time Formats
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 and Time Formats
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. "Mike" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 and Time Formats
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 -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "Mike" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving in 2007 and 2003 formats at the same time | Excel Discussion (Misc queries) | |||
TIME FORMATS IN EXCEL | Excel Discussion (Misc queries) | |||
Time formats in Excel | Excel Discussion (Misc queries) | |||
Why do conditional formats appear by themselves in Excel 2003? | Excel Discussion (Misc queries) | |||
Time formats in Excel 2003 | Excel Discussion (Misc queries) |