Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for Excel
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for Excel
=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. -- David Biddulph "Dannigirl" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |