View Single Post
  #1   Report Post  
TeddyTash TeddyTash is offline
Junior Member
 
Posts: 15
Question 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?