Formula to Average times...again

D

Denise

I am still having some problems with trying to find a formula for this. I
have in my spreadsheet the following:

HOME ADMIT ELAPSED TIME
x 00:10
5014-2 00:20
4017 00:15
x 00:07
ICU 00:25

I have formulas to figure the elapsed time on all pateints. I need a
formula to figure the average time of admits only.

I got help earlier and the formula works to average time for patients that
go home but I could not get it to work on the admits. The formula is:

=SUMIF(HOME,"x",ELAPSED TIME)/COUNTIF(HOME,"x")

Thanks for any help I can get. I have tried all kinds of things to average
the time for admits.
 
B

Bob Phillips

=AVERAGE(IF(ADMIT<>"",ELAPSED TIME))

which is an array formula, so commit with Ctrl-Shift-Enter
 

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

calculating average handling time 7
Calculate elapsed time excluding specific timeframe 10
Average Time for Specific Item 10
How to average hh:mm:ss when hh is 00 4
Return column values based on criteria (HLOOKUP & VLOOKUP?) 0
Determine if night shift by start & end time 2
Insert Row and Countif Macro 1
Time lapse to display in minutes 2

Top