1 min readfrom 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.

submitted by /u/Farimer123
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article