ExcelBanter - negative time

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - negative time (https://www.excelbanter.com/excel-discussion-misc-queries/3203-negative-time.html)

joshua

negative time

how do i display negative time? i have an overtime worksheet and i want to
subtract time to represent time missed.

Harald Staff

Hi

Set the calendar format to 1904 in Tools Options.

Note that dates will shift 4 years 1 day if you have dates in there. Post
back if that's a problem.

HTH. Best wishes Harald

"joshua" skrev i melding
...
how do i display negative time? i have an overtime worksheet and i want to
subtract time to represent time missed.

All times are GMT +1. The time now is 01:48 PM.