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