Function Help

[DW]

Example:
A B C D
F
1 Job Function Start Time End Time Total Time Pre Sort
2 PS 8:00am 8:10am .10
..40
3 AC 8:15am 8:20am .05
Acusort
4 TS 9:00am 9:20am .15
..20
5 AC 10:15am 10:30am .15 Truck
Sort
6 PS 11:00am 11:30am .30
..15

I am tring to come up with a function for F2, F4 & F6 that will total the
time accured for each job function. Column A2 & A6 should total .40 min in
column F2. If anyone has any idea I would appreciate it. Thanks

 

[Art Farrell]

Hi DW,

You can use the following SUMPRODUCT formulas in your cells:

F2 =SUMPRODUCT((A2:A10="PS")*(D210))

F4 =SUMPRODUCT((A2:A10="AC")*(D210))

F6 =SUMPRODUCT((A2:A10="TS")*(D210))

CHORDially,
Art Farrell