Forum Discussion
Solved
Trying to work with time criteria
I have a spreadsheet with patient appointment times and patient check in times both formatted as mm/dd/yyyy h:mm A/P. I am trying to analyze how often patients are checking in late, and how late are...
- I believe your response has led me to the answer. I think your original formula had a typo, and I applied it incorrectly. I believe you meant to suggest 1440*(J3-E3). When I do that and use the J3-E3 result that produced result in decimal format instead of the result in hh:mm format, it works!! THANK YOU.
It might be easier to calculate the difference as a number of minutes instead of a text value that represents time.
Use =1440*(J3-E3) and format the cell with the formula as General or as Number with 0 decimal places.
You can then use formulas such as =COUNTIF(difference_range, ">3") etc.
Edited to correct mistake
HansVogelaar Thanks for your response. I used the formula you noted, and the result is 50761039. In this case, the actual difference between appointment time and check in time was -4 minutes (the patient checked in 4 minutes early). I am stumped... 🙂