Formula for Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dannigirl - 30 Sep 2007 16:17 GMT

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.

Reply to this Message

Teethless mama - 30 Sep 2007 16:29 GMT

=SUM(A1:A3)
format cell as [h]:mm

> How do I add times together in order to get the total hours I worked?
>
[quoted text clipped - 5 lines]
>
> Thank you in advance.

Reply to this Message

David Biddulph - 30 Sep 2007 16:37 GMT

=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.

Signature

David Biddulph

> How do I add times together in order to get the total hours I worked?
>
[quoted text clipped - 6 lines]
>
> Thank you in advance.

Reply to this Message