Custom format the total cell as:
[h]:mm

The square brackets prevent the hours from rolling over into days.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Richard T" <Richard wrote in message
...
I am trying to add up a range of times that will eventually be greater than
24hours, but I need to express this in hours and minutes. I then need to
work
out an average for this time.