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?