Sum of Hours/mins
 

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?

Sum of Hours/mins
 

hi!


format A7

custom [hh]:mm

-via135


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=539015

Perfect, thank you.