This task is overwhelming my day. I have tried formulas but am still not having luck with some of the formatting that has been suggested here because it is over my head. I can email the workbook so that it can be seen and tinkered with.
I must keep a running tab of the length of time for admission to the floor from an outpatient setting to an inpatient setting and break that down into the varied floors and/or units. Then I must compile those that fall into categories of <60 minutes, 61-120 minutes, >120 minutes.
If I could get the entries in columns C and D to be entered without the colon it would speed things up immensely. The problem is, that Column E does not recognize the format in the two preceeding columns as time if I try to change the current time format. Column E is "elapsed time from C to D" in MINUTES.
I also have a problem with columns O,P,Q. I cannot figure out how to get P to populate. O and Q seem to be working. I have been having to manually read and fill in the cells if the times fall in the 61-120 category.
I must keep a running tab of the length of time for admission to the floor from an outpatient setting to an inpatient setting and break that down into the varied floors and/or units. Then I must compile those that fall into categories of <60 minutes, 61-120 minutes, >120 minutes.
If I could get the entries in columns C and D to be entered without the colon it would speed things up immensely. The problem is, that Column E does not recognize the format in the two preceeding columns as time if I try to change the current time format. Column E is "elapsed time from C to D" in MINUTES.
I also have a problem with columns O,P,Q. I cannot figure out how to get P to populate. O and Q seem to be working. I have been having to manually read and fill in the cells if the times fall in the 61-120 category.
