vlookup - i think
I have the following data:
Day of Week Time Minutes Non-Work Day/Time Minutes
Tuesday 11:48 AM 3
Tuesday 11:51 AM 1
Wednesday 3:01 PM 1
Wednesday 3:02 PM 1
Wednesday 3:18 PM 1
Friday 3:37 PM 2
Friday 3:48 PM 7
Friday 3:59 PM 9
Friday 4:14 PM 2
Friday 4:17 PM 26
Sunday 7:28 PM 2
Monday 2:50 PM 1
Looking for a formula that will tell me the number of minutes called in
NON-work days or times (M-F work days, 8-5 work times).
|