Hide Cell value

[jonjon_01]

Morning all,

Yet another question for the Excel gurus.

I'm building a spreadsheet that would give me the hours used by a person. Basically, it's a maintenance log and I would like to keep track of the time it took to fix the equipment.

So I have the formula calculate the sum of "=SUM(H5-E5)" which gives me the hour and minutes worked.

So I have the sheet calculate the sum of the hours used as "=SUM(I5:I34)"

Everything works well, but I would like the formula to skip over anything with no data in it. An example for the situation is that I have the time an issue was noticed but not the time the issue was fixed which gives me a "#VALUE!". This causes the formula to not function properly. I would like the cell to be skipped until I can get the data to input into the missing cell.

Please help.

 

[xl_psychic]

Hi,

If E5 houses issue noticed time and H5 houses issue fixed time, this formula should be helpful...

=if(or(E5="",H5=""),"",H5-E5)

Hope this helps...

 

[NBVC]

Should your first formula be =Sum(E5:H5)?

Perhaps, you can avoid the error reply by placing an error-handling argument such as: =IF(SUM(E5:H5)=FALSE,0,SUM(E5:H5))

Then the second formula should work properly.

 

[jonjon_01]

XL_Psychic,

Thank you! That's exactly what I needed. It worked like a charm.