| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Hi
Set your spreadsheet to 1904 calendar (Tools Options menu) to display negative time. (Note that dates will shidt 4 years 1 days off by doing this). HTH. Best wishes Harald "james" skrev i melding ... I am trying to set up a spreadsheet to record staff flex-time. Formating to record time produces errors when negative are introduced. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating negative time. | Excel Discussion (Misc queries) | |||
| How do you enter a negative time number in Excel? | Excel Discussion (Misc queries) | |||
| Calculating negative time & creating scrol bars for fixed size txt box. | Excel Discussion (Misc queries) | |||
| negative time | Excel Discussion (Misc queries) | |||
| calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
Hybrid Mode
