Hi all,
Trying to find a formula count the total number of hours in column A for all Work Types equal to RM or PM etc? =COUNTIF(G2:K5,"*RM*") will only count the number of times RM appears, however how can I count the total number of hours for all instances of RM? Any help would be greatly appreciated.
Time Work Type
07:38:00 RM
05:02:33 QUOTE
04:34:00 RM
04:26:49 RM
01:10:00 PM
00:45:10 RM
00:39:47 PMSTA
00:27:22 PM
00:22:10 PM
00:14:25 PM
Bookmarks