Displaying a negative time


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
 
Ad

Advertisements

B

Bob Phillips

Change to 1904 date system

Tools>Options> Calculation>1904 date system

HTH

Bob
 
C

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
 
Ad

Advertisements

F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DIsplaying negative time values 1
Negative Time 7
Time / Negative Time 2
negative times. 1
Negative Time Calculation 3
negative time values? 8
Excel Negative Time Format 8
Showing negative 'Times' in cells. 1

Top