Formula for Excel

G

Guest

How do I add times together in order to get the total hours I worked?

i.e.: I worked 8hrs and 57minutes (8:57) on Monday, 8hrs and 26minutes
(8:26) on Tuesday, and 7hrs and 37 (7:37) minutes on Wednesday.

What formula could I use to get the total hours I worked? The formula should
tell me I worked a total of 25 hours.

Thank you in advance.
 
D

David Biddulph

=SUM(A1:A3) or =A1+A2+A3
Format the result as [h]:mm to get the result as 25:00

If you want the result as a number of hours to use in subsequent
calculations, use =SUM(A1:A3)*24 or =(A1+A2+A3)*24
and in this case format the result as General or Number, not as time.
 

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

Top