I have a challenge for someone out there(maybe it's just me being challenged):
I am not going to be the end user on this and I am trying to avoid using vb if I can.
I work at a hospital and we are trying to track time through the emergency department. Everything is based on the time a patient walks through the door.
All of this is simple enough.
Door time(ColC), Triage time(ColD), Door to Triage(ColE), Doc with Patient Time(ColF), Door to Doc(ColG), etc.
How many minutes from door to triage(E23) = Triage time(D23) - Door time(C23) ....Data entry done as "07:45" Format [h]:mm
Now, when the times cross midnight I just add the date: Door Time "10/17/14 23:45", Triage Time "10/18/14 00:15" Format [h]:mm
Slows down data entry a little, but it's not that common...they can deal with it!
So that was all working wonderfully, except the data entry piece. Pausing to enter a colon for every measure of time was taking forever, much faster to enter the times as a 4 digit string "2345" instead of "23:45"
I started playing around with the data entry and functionality
Door Time(ColC) is now entered in a 4 digit string "2345", format 00\:00, so it looks like time, but it's not!
Inserted a new column in ColD, Formula =1*TEXT(C23,"00\:00"), Format [h]:mm ...now it's time
I did this after each Col where a "time" was entered. The result from the example above now lands in G23 =F23-D23, Format [h]:mm
I hid these new columns so the end user isn't confused by their existence.
It's working! I'm really not very good at this stuff, so I was kind of proud that I made it this far by myself:
So......what do I do when the time crosses midnight? I can't figure out how to work the date back into the equation.
I was thinking that I could format the new columns with date and time, it defaults to "1/0/0" and if ColF < ColD add a day? But I don't know how...Any help would be greatly appreciated!
~Robert
I am not going to be the end user on this and I am trying to avoid using vb if I can.
I work at a hospital and we are trying to track time through the emergency department. Everything is based on the time a patient walks through the door.
All of this is simple enough.
Door time(ColC), Triage time(ColD), Door to Triage(ColE), Doc with Patient Time(ColF), Door to Doc(ColG), etc.
How many minutes from door to triage(E23) = Triage time(D23) - Door time(C23) ....Data entry done as "07:45" Format [h]:mm
Now, when the times cross midnight I just add the date: Door Time "10/17/14 23:45", Triage Time "10/18/14 00:15" Format [h]:mm
Slows down data entry a little, but it's not that common...they can deal with it!
So that was all working wonderfully, except the data entry piece. Pausing to enter a colon for every measure of time was taking forever, much faster to enter the times as a 4 digit string "2345" instead of "23:45"
I started playing around with the data entry and functionality
Door Time(ColC) is now entered in a 4 digit string "2345", format 00\:00, so it looks like time, but it's not!
Inserted a new column in ColD, Formula =1*TEXT(C23,"00\:00"), Format [h]:mm ...now it's time
I did this after each Col where a "time" was entered. The result from the example above now lands in G23 =F23-D23, Format [h]:mm
I hid these new columns so the end user isn't confused by their existence.
It's working! I'm really not very good at this stuff, so I was kind of proud that I made it this far by myself:
So......what do I do when the time crosses midnight? I can't figure out how to work the date back into the equation.
I was thinking that I could format the new columns with date and time, it defaults to "1/0/0" and if ColF < ColD add a day? But I don't know how...Any help would be greatly appreciated!
~Robert