Sum of Hours/mins

T

TeddyTash

I need to know how to add hours and minutes, and get the sum to b
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 an
minutes which should be "27:30".

Is this possible
 
Top