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

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

Want to read more?

Check out the full article on the original site

View original article