| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Add up the hours for each month
Column A consists of dates (format example: Thursday, May 06). Date is
entered when vacation time or sick time is taken. Column B consists of the hours of vacation for that day Column C consists of the hours of sick time for that day Column E consists of the months (January, February, etc.) Column F consists of the hours of vacation taken for that month Column G consists of the hours of sick time taken for that month Can someone tell me what the formula would be for cells in columns F & G? I imagine it would be some kind of lookup function or count function. Thank you in advance -- ~Jeff~ [Microsoft Windows XP Pro,Office 2000] |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UserForm to select current month or earlier | Excel Discussion (Misc queries) | |||
| How to extract month number from month name | Excel Discussion (Misc queries) | |||
| How can i tell excel to cumalative the hours so 17:00 + 10:00 = 2. | Excel Discussion (Misc queries) | |||
| time-sheet record with over 24 hours | New Users to Excel | |||
| Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) | |||
Threaded Mode
