•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Convert times to military time ABOVE 24:00
Hi everyone, I'm trying to take the average of a list of times spanning both sides of midnight, such as:
12:30 AM, 1:19 AM, 10:51 PM, 11:26 PM, etc.
When I take the average of two times on different sides of midnight, say 1:19 AM and 10:51 PM, it thinks the average is 12:05 PM. No, it's 12:05 AM, it's calculating the past AM hours wrong. A way to fix this would be to convert 1:19 AM to 25:19, like military time, but this doesn't seem to work and it just comes out at 1:19 AM.
[link] [comments]
Want to read more?
Check out the full article on the original site