View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default how do i calculate negative hours in excel

hi
the 1900 date system will not show negative time. the 1904 date system will
but in switching it will throw off all of your other dates in the file by
adding 4 years and 1 day to all dates. tricky situation so it depends on how
desperate you are for negative times.

Regards
FSt1


"suewalton21" wrote:

I have a staff time sheet which calculates hours worked
It also calculates additional hours worked
How do I get it to show minus hours worked
eg usual cumulative hours = 20
actual cumulative hours =16