Minus Time Number Calcs

[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

 

[Peo Sjoblom]

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