Formula help - Time Management

Shazz

New member
Joined
May 9, 2012
Messages
15
Reaction score
0
Points
0
Hi All,
I wonder if anyone can help me, Attached is a spreadsheet that i have created for Time Management but I do not know how to get rid of the ######## in Column J & L. Can anyone advise how to do this.

Shazz
xx
 

Attachments

  • Time Management.xls
    87.5 KB · Views: 73

atanuchanda

New member
Joined
Jun 14, 2012
Messages
1
Reaction score
0
Points
0
Hi Shazz,

I went thru your file and found problem quite easy to fix. Write the formula in Cell I2 =IF(D2="","",SUM(E2-D2+F2)+(G2-H2)-(F2)) and overwrite the cells below with it.

Thanks Atanu.
 

CheshireCat

New member
Joined
Dec 30, 2011
Messages
121
Reaction score
0
Points
0
Location
Victoria, Canada
Excel Version(s)
Microsoft Excel 2013
Hi Shazz,

If the result of a date/time calculation is negative, Excel will display #######.

In I2 you might also try:

Code:
=MAX(E2-D2+G2-H2,0)

Copy/autofill down.

Cheers,
 
Top