Displaying a negative time

  • Thread starter Thread starter Colin Weir
  • Start date Start date
C

Colin Weir

Hi There

I've created a time sheet in excel for my work. One of my colleagues
however owes the organisation some hours. Sadly this is right at the
beginning of the year so I am having a bit of a problme setting it up
to display this.

She owes the organisation 7hrs 45mins. I tried entering into the cell
30/12/1903 16:15:00 however this then just displays that entry and
not -7:45:00

Is there any way I can get this to work?

Cheers

Colin
 
Hi

I think I've sorted it - I just put some figures in some cells off
screen and then done a calculation on them to give me the desired
result.

Thanks

Colin
 
Excel will calculate negative time, it just won't display it. You can use
the following to get it displayed:
=IF(A1<0,"-","")&TEXT(ABS(A1),"hh:mm:ss")

Regards,
Fred
 
Back
Top