Hi, I'm trying to count the number of patients at a given hour
7/27/2015 13:51
7/28/2015 17:50
13:51 17:50 (formula to convert this into 41:50) so patient will be counted every hour until 5:50 pm the following day
Thank you!
J
Hi, I'm trying to count the number of patients at a given hour
7/27/2015 13:51
7/28/2015 17:50
13:51 17:50 (formula to convert this into 41:50) so patient will be counted every hour until 5:50 pm the following day
Thank you!
J
13:51 to 17:50 next day should be 28:00 , why 41:50?
Quang PT
Hi
Try to format the time differences using "mm:ss;@"
I do not know if is ";" or ","
Regards
I added 24 hours to 17:50 because patient was here past midnight
Hi Jomejorada
You do not need to add 24h
See the file
Hi everyone, thank you for all your responses. I really appreciate your time. But I guess I was not clear on what I needed so I am attaching a file that shows why I need to convert those times (highlighted) past midnight. I want to count number of patients in the unit by hour.
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks