Formula for Excel
=SUM(A1:A3)
format cell as [h]:mm
"Dannigirl" wrote:
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.
|