Minus Time Number Calcs

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I can calculate positive time ok but can't find a way of showing negative
time numbers (i.e. nagative hours on a flexi-time sheet.

Any help appreciated
 
You can't, that is if you are using default setting. You can select 1904
date system under tools>options>calculations.
Note that all dates in workbooks created earlier will have 1462 days added
to them and you can put 1462 in a cell, copy it
and paste special add over the earlier dates
 
Back
Top