Displaying a negative time

[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

 

[Bob Phillips]

Change to 1904 date system

Tools>Options> Calculation>1904 date system

HTH

Bob

 

[Colin Weir]

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

 

[Fred Smith]

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