hi
i have a spreedsheet with three columns of data
column CAholds the op number
column CB holds the fault description
column CC holds the downtime
what i want to do is count the amount of downtime for each fault
decription when it occurs against an op number
OP915 SPINDLE FAULT 00:00:25
OP915 SPINDLE FAULT 00:00:13
OP915 SPINDLE FAULT 00:00:02
OP915 SPINDLE FAULT 00:00:05
OP018 LOWER LIFTING 00:01:09
OP018 LOWER LIFTING 00:02:33
OP018 LOWER LIFTING 00:01:37
OP018 LOWER LIFTING 00:03:30
OP018 LOWER LIFTING 00:01:29

result
OP915 SPINDLE FAULT 00:00:45
OP018 LOWER LIFTING 00:10:18


thanks

kevin