A Negative problem

[poppedinsouled]

Hi,

I have fashioned a time sheet to measure my working day/week


The problem I'm having is when i seperate my overtime i.e I work more than 7hrs:30m is fine I can minus one from the other i.e I work 9hrs:30 minus 7hrs:30 equal 2 hrs overtime or 2:00 in the cell.

The problem is when I work less i get "#######" in the cell, how do i get round this? I just want it to show "00:00"

Any help would be appreciated

[MickG]

Hi If Your Total time worked is in "A1" and your stardard day is in "B1" then this formula should give you your required result.

Please Login or Register  to view this content.

Regards mick

[oldchippy]

An alternative is this with the cell custom formatted as hh:mm

=IF(A1<B1,0,A1-B1)