💻 Software
How to get Average for time in Excel 2007?
Fresh7 days ago
Mar 15, 2026222313 viewsConfidence Score0%
0%
Problem
I have these values I highlighted all these cells and went to format cells -> custom -> and choose mm:ss I then tried to use the built in average function in Excel 2007 The result is 0.0 Of course this is not the number result that it should be(I have not calculated it manually yet but I am sure it…
Error Output
01:15 05:00 01:31 02:00 02:21 02:39 03:29 08:00
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How to get Average for time in Excel 2007?
Low Risk
If you just want to do this quickly, select as the option from the drop down box and it should work as expected: I have tried and cannot replicate your results, I think that you are messing up hours/minutes/seconds, Time fields are usually stored as…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix