Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Negative times
Am I right in saying that the 1904 date system allows negative times to be
displayed but the 1900 system doesn't? I have tried this in the timesheet I have been developing and it seems to be solving my problems anyway. I don't understand why though -can anyone explain. Regards, Gavin |
#2
|
|||
|
|||
IIRC:
I believe it was an effort to be 1-2-3 compatible when XL was ported to PC. The original Excel, (MacXL 1) used the 1904 date system and could display negative times, as it still does. When MS ported XL to Windows, to be compatible with the dominant PC spreadsheet program, they deferred to the 1-2-3 1900 date standard, which added the non-existent Feb 29, 1900, and didn't display negative times. In article , "gavin" wrote: Am I right in saying that the 1904 date system allows negative times to be displayed but the 1900 system doesn't? I have tried this in the timesheet I have been developing and it seems to be solving my problems anyway. I don't understand why though -can anyone explain. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i enter negative times in Excel & how can they be 'fiddled. | Excel Discussion (Misc queries) | |||
Negative times | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
SUMPRODUCT ON TIMES | Excel Worksheet Functions | |||
How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) |