Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating adjacent columns in a work schedule
You could throw your table into a pivot table with automatic sums on the hour
count field for each worker. "CCsoccer14" wrote: I am working on a schedule where there are many different workers, and many different shifts of different lengths are being used. I have been trying to create a formula that sums the total hours for each person, based on the name in the adjacent column. For example: A B C 4-8pm Mark 4.00 6-8pm Dave 2.00 8pm-11pm Mark 3.00 My hope is that there is some conditional formatting to say if column B = "Mark", sum the amounts adjacent to the name Mark in column C, to the output value would be 7.00 hours. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop-Down Boxes In Adjacent Columns | Excel Discussion (Misc queries) | |||
Matching Adjacent Columns? | Excel Worksheet Functions | |||
Convert Text to Columns with Excel 2007 beta does not work well | Excel Worksheet Functions | |||
how do i calculate a work schedule in excel? | Excel Discussion (Misc queries) | |||
Want labels of columns to display on each page when printing work. | Excel Discussion (Misc queries) |