Prodetik
New member
- Joined
- Jul 23, 2019
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2016
New to this forum, and I would very much appreciate any assistance. I have a software that tracks data for medication administration in a medical facility. The data exports in the format seen in the attached file (Test). I am needing a formula that can tell me how many hours & minutes between the stated Administered Time and Recorded Time.
There are obviously mixed formats for the dates and times, depending on the cell viewed. I have tried several solutions, but can't get it right. Additionally, I don't believe the times are being recognized as 'Time'.
We administer thousands of medications per day, and they must be documented/recorded in 30 minutes or less, after the administration. I'm just trying to figure out a way monitor for deviance from policy. Thanks, again, for any assistance possible!
Prodetik
There are obviously mixed formats for the dates and times, depending on the cell viewed. I have tried several solutions, but can't get it right. Additionally, I don't believe the times are being recognized as 'Time'.
We administer thousands of medications per day, and they must be documented/recorded in 30 minutes or less, after the administration. I'm just trying to figure out a way monitor for deviance from policy. Thanks, again, for any assistance possible!
Prodetik