Sum of Hours/mins

[TeddyTash]

I need to know how to add hours and minutes, and get the sum to be
displayed in hours and minutes, rather than days.

Example:
A1 05:30
A2 05:30
A3 05:30
A4 05:30
A5 05:30

A7 =SUM(A1:A5)

A7 displays "03:30", but I wish it to display the total hours and
minutes which should be "27:30".

Is this possible?


--
TeddyTash

[via135]

hi!


format A7

custom > [hh]:mm

-via135

[TeddyTash]

Perfect, thank you.


--
TeddyTash