Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sum of Hours Per Month
I have been given a data set which contains work hours and dates in the form
of mm/dd/yy. I am trying to sum all the hours worked in each month. A co-worker suggested I use sumproduct but I'm still not able to achieve the process. Additionally, the data crosses over years, so I am not quite sure how to create a fomula that takes the year into account. Any help would be great. Thanks much. -- Zachary Baker |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to convert hours and minutes to hours and tenths. | Excel Discussion (Misc queries) | |||
Can this adjusted GPA formual be accomplised? | Excel Discussion (Misc queries) | |||
adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
Subtracting paid hours from unpaid hours | Excel Worksheet Functions | |||
Add up the hours for each month | Excel Worksheet Functions |