•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Mod and Average when calculating time difference
Hi Excel Brain Trust,
I'm trying to find the average of time differences.
I have a range of calculated values that are time differences between two times, using the "MOD" formula:
=IFERROR(MOD(range-range,1),"N/A")
The result is formatted to hh:mm
However, I cannot seem to find the average of the results. =Average produces results that I cannot figure where they're coming from.
Any ideas? Unfortunately my client strongly prefers the hh:mm format.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#real-time data collaboration
#real-time collaboration
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#AI formula generation techniques
#formula generator
#Excel
#MOD formula
#time difference
#average
#hh:mm format
#IFERROR
#range
#cell formatting
#date/time arithmetic
#time calculation
#percentage
#numeric conversion