how do i calculate negative hours in excel
 

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

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

how do i calculate negative hours in excel
 

If you have 20 in A1 and 16 in A2, the formula =A2-A1 will give you a
negative result.
If that isn't what you want, you'll need to be more specific with your
question.
--
David Biddulph

"suewalton21" wrote in message
...
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

how do i calculate negative hours in excel
 

Sorry but that does not give me a negative number Here is a copy

25:40 24:00 1:40
28:35 28:00 0:35
31:35 32:00 0:25
31:35 36:00 ####

"David Biddulph" wrote:

If you have 20 in A1 and 16 in A2, the formula =A2-A1 will give you a
negative result.
If that isn't what you want, you'll need to be more specific with your
question.
--
David Biddulph

"suewalton21" wrote in message
...
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