Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count hours per month
Hi All
I have a spreadsheet where i need to count the number of hours and minutes spent working on products per month In cell range 'H' i have the time spent working i.e. 00:40 (40 minutes) In cell range 'P' i have the dates i.e. 15/09/07 How do i calculate how many hours and minutes were spent working on products during Jan,Feb,Apr etc? I have tried this formula, but it only works for some months (works in January, but not in September) =SUMPRODUCT(--(TEXT('With costs'!P2:P5000,"mm yyyy")="08 2007"),--('With costs'!H2:H5000)) Many thanks Derek |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum of Hours Per Month | New Users to Excel | |||
How can I count hours & minutes??!! | Excel Discussion (Misc queries) | |||
count TIME that is GREATER than 24 hours | Excel Worksheet Functions | |||
Add up the hours for each month | Excel Worksheet Functions |