Hi,
I can't seems to get the difference in time correct.
A1 = 18:33
A2 = 00:56
A3 = AVERAGE(A1:A2) = 22:44
All cells are formated as hh:mm
I got the difference to be 9hrs 44mins but the formula shows 22:44. What did I do wrong?
Hi,
I can't seems to get the difference in time correct.
A1 = 18:33
A2 = 00:56
A3 = AVERAGE(A1:A2) = 22:44
All cells are formated as hh:mm
I got the difference to be 9hrs 44mins but the formula shows 22:44. What did I do wrong?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks