•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
Tagged with
#rows.com
#real-time data collaboration
#Excel compatibility
#Excel alternatives for data analysis
#average
#military time
#midnight
#list of times
#time calculation
#conversion
#12:30 AM
#1:19 AM
#10:51 PM
#11:26 PM
#time averaging method
#time format
#calculate
#12:05 PM
#12:05 AM
#AM hours