Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Allocate Time Range over each hour of the day?
Greatings from the SF Bay Area. I'm lost on a particular problem.
I have patients that are in and out of different departments like ED and Clinics. I'd like to take an arrival-to-discharge time, and spread the minutes/hours they were 'in-department' during the day. For example, Patient 'A' presents at 14:15 and is discharged at 16:25. I'd like to allocate his time as .75 hours (or 45 monutes) between 14:00 and 14:59, 1 hour between 15:00 and 15:59, and .42 hours (25") between 16:00 and 16:59. I haven't a clue how to efficiently do this. Thanks in advance for help on this... hopefully it will shorten waits in the Emergency Room. I envision a spreadsheet delineating Hour of Day on the top row, and patients down column 'A'. Each patient stay would be noted as hours or minutes in a row over the appropriate hour columns. -Bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to convert range of time into 1 hour increment | Excel Discussion (Misc queries) | |||
"h:mm" format, but 12-hour time, not 24-hour time? | Excel Discussion (Misc queries) | |||
Changing decimal time into 24 hour time and reverse | Excel Discussion (Misc queries) | |||
how to calculate time start & time finish in quarter hour | Excel Discussion (Misc queries) | |||
convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) |