hh.mm calculation won't ignore blank cells

[majdmann]

I'm trying to calculate duration to find average wait times in an ER. I have a column for check in and a column for seen by doc. the calculation returns #VALUE! if a time isn't entered. How do I get it to ignore blanks?

Example:

=AH2-AE2+(AH2<AE2)

<AE2) p <AE2)<AE2)< <AE2)>where AH2 is check in and AE2 is seen by doc.

 

[Gerald Higgins]

Hi, welcome to the board.

It looks as if part of your formula is missing.
Does it include < or > symbols ? If yes, put spaces around them (this is a recognised bug on this board).

I don't know what your formula should be, but you could put in some kind of error handler, like this

=if(or(AH2="",AE2=""),"TIME MISSING",(REST OF YOUR FORMULA))

Replace "TIME MISSING" with whatever you want to do if time data is not complete.
Replace (REST OF YOUR FORMULA) with, well, you can probably work it out

 

[barry houdini]

You can use COUNT to ensure you have 2 time values populated, i.e.

=IF(COUNT(AE2,AH2)=2,AH2-AE2+(AH2< AE2),"")<AE2) p <>

 

[majdmann]

Yup - it was (AI2 < AF2) and thanks! worked like a charm