Forum Discussion
Using excel as a timesheet
With the default settings, Excel does not support negative time.
There is a workaround, but it will shift all existing dates in the workbook:
- Select File > Options.
- Select Advanced.
- Scroll down to the section 'When calculating this workbook'.
- Tick the check box 'Use 1904 date system'.
- Click OK.
- This will affect the specified workbook only.
Alternatively, use a formula such as =24*(A1-B1) to subtract the time in B1 from that in A1, and format the cell with the formula ad General or as Number. It will display the difference in decimal hours instead of as time.
With the default settings, Excel does not support negative time.
There is a workaround, but it will shift all existing dates in the workbook:
- Select File > Options.
- Select Advanced.
- Scroll down to the section 'When calculating this workbook'.
- Tick the check box 'Use 1904 date system'.
- Click OK.
- This will affect the specified workbook only.
Alternatively, use a formula such as =24*(A1-B1) to subtract the time in B1 from that in A1, and format the cell with the formula ad General or as Number. It will display the difference in decimal hours instead of as time.
Thank you. using the 1904 seems to have done the trick! much appreciated.
