=SUM(A1:A5)*24 for totalling hours and minutes is not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to total up hours worked in a one week time period. I found the
noted formula if the total is going to be >24 hours. However, I cannot get
an accurate total. Any thoughts comments, would be greatly appreciated.
 
Either use

=SUM(A1:A50)

and format as [hh]:mm under format>cells>number>custom

or format as general and use

=SUM(A1:A50)*24
 
Remember that your formula return hours. This means that if the formula gives:

1.25 ===> this really means one hour 15 minutes.
_________________________
Gary's Student
 
You must log in or register to reply here.

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

Adding up total hours worked on employee schedule using various criteria 0
Adding Days and Hours 8
help with adding up hours and mins please 3
How to Sum Time in Hours & Minutes 9
Adding Hours Worked Correctly 3
How do I sum hours and minutes totalling over 24 hours? 1
How do add time/hours to get answer in hours if Ans>24 2
Calculating total work week hours 2

Back
Top