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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the remaining weekdays in a data range excluding holidays and start/end dates 5
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Hours and sum of hours 2
problem with time subtraction 7
Detailed Countdown 2
Subtracting time...again 2
Calculate end date and time 1
Sum value between two dates and copy to new cell 7

Top