find a value in a table, go to the previous column and add that co

P

Paul

Hello I hope you can help

I have a monthly roster that looks like this
A....B......C.........D.........E...........F..........G
1................................ Mon.....Tues....Wed......
2..start..finish...HRS...3 Apr.....4 Apr...5 Apr.....
3..7:00..15:00..7:30........................................
4..7:00..15:30..8:00...TRICIA...SUE....THERESE
5..7:00..15:30..8:00.........................................
6..7:30..13:00..5:00...JEANNE..ANNA...FIONA
8..7:30..16:00..8:00.................CHRIS..............

I would like to total the hours for each day. Hours are in cell D3:D8. So
monday would equal 13, tues 21 etc.
Is there a formula that I can place in the cell which will add the days
hours together?

Your help is greatly appreciated
 
J

JR

Why don't you try a little different layout with the names to the left...
4/3/06 4/4/06 4/5/06
MON TUE WED
Tricia 8:00 7:00
Sue 7:00
Jeanne 8:00
Chris 8:00 8:00
16 15 15
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif between Time stamps and have - value 0
How do I find a match for three variables to determine the result? 2
How to: Convert time value to a number 2
Modifying a complex date formual to count months 4
The Tueday prior to a holiday... 8
use an input box to select a range and copy to another worksheet 6
TimeSheet Using 100 Minutes & Rounding to .25 2
If time Go to Function 1

Top