Spreadsheet: 846368d1697607082-conditional-formatting-issue-where-cell-has-a-formula-working-with-time-fm-test
Sheet: Sheet1

 | Major Fatigue Breaks Total |  |  |  |  |  |  | Major Fatigue Breaks Total
 | Short Fatigue Breaks Total Time |  |  |  |  |  |  | Short Fatigue Breaks Total Time
 | WIM Time To Mine |  |  |  |  |  |  | WIM Time To Mine
 | Total Time To Mine |  |  |  |  |  |  | Total Time To Mine
 | Total Time @ Wiluna |  |  |  |  |  |  | Total Time @ Wiluna
 | Loading Time |  |  |  |  |  |  | Loading Time
 | Unloading Time |  |  |  |  |  |  | Unloading Time
 | WIM Time To Geraldton |  |  |  |  |  |  | WIM Time To Geraldton
 | Total Time To Geraldton |  |  |  |  |  |  | Total Time To Geraldton
 | Total Time @ Mt Magnet ReFuel |  |  |  |  |  |  | Total Time @ Mt Magnet ReFuel
 | Trip Distance (k) | Total WIM Time |  | 1 day, 2:58:00 |  |  |  | Trip Distance (k) | Total WIM Time |  | 1 day, 2:58:00
 |  | Total Trip Time |  |  |  |  |  |  | Total Trip Time
 | OUTBOUND |  |  | HOMEBOUND |  |  |  | OUTBOUND |  |  | HOMEBOUND
 | WIM #1 < 5H |  |  | WIM #1 < 5H |  |  |  | WIM #1 < 5H |  |  | WIM #1 < 5H
 | Break #1 ~20m |  |  | Break #1 ~20m |  |  |  | Break #1 ~20m |  |  | Break #1 ~20m
 | WIM #2 < 5H |  |  | WIM #2 < 5H |  |  |  | WIM #2 < 5H |  |  | WIM #2 < 5H
 | Break #2 ~20m |  |  | Break #2 ~20m |  |  |  | Break #2 ~20m |  |  | Break #2 ~20m
 | WIM #3 < 5H |  |  | WIM #3 < 5H |  |  |  | WIM #3 < 5H |  |  | WIM #3 < 5H
 | Break #3 ~20m |  |  | Break #3 ~20m |  |  |  | Break #3 ~20m |  |  | Break #3 ~20m
 | WIM #4 < 5H |  |  | WIM #4 < 5H |  |  |  | WIM #4 < 5H |  |  | WIM #4 < 5H
 | Break #4 ~20m |  |  | Break #4 ~20m |  |  |  | Break #4 ~20m |  |  | Break #4 ~20m
 | WIM #5 < 5H |  |  | WIM #5 < 5H |  |  |  | WIM #5 < 5H |  |  | WIM #5 < 5H
 | Break #5 ~20m |  |  | Break #5 ~20m |  |  |  | Break #5 ~20m |  |  | Break #5 ~20m
 | WIM #6 < 5H |  |  | WIM #6 < 5H |  |  |  | WIM #6 < 5H |  |  | WIM #6 < 5H
 | Break #6 ~20m |  |  | Break #6 ~20m |  |  |  | Break #6 ~20m |  |  | Break #6 ~20m
 | WIM #7 < 5H |  |  | WIM #7 < 5H |  |  |  | WIM #7 < 5H |  |  | WIM #7 < 5H
 | Break #7 ~20m |  |  | Break #7 ~20m |  |  |  | Break #7 ~20m |  |  | Break #7 ~20m
 | [NAME] |  |  | Transfer |  |  |  | [NAME] |  |  | Transfer
 | Onsite @ MM Fuel |  |  | Onsite @ MM Fuel |  |  |  | Onsite @ MM Fuel |  |  | Onsite @ MM Fuel
 | O/N Break |  |  | O/N Break |  |  |  | O/N Break |  |  | O/N Break
 | OUTBOUND DATA |  |  | HOMEBOUND DATA |  |  |  | OUTBOUND DATA |  |  | HOMEBOUND DATA
 | Work #1 < 5H |  |  | Work #1 < 5H |  |  |  | Work #1 < 5H |  |  | Work #1 < 5H
 | 06:00:00 | 11:05:00 |  | 06:00:00 | 07:34:00 |  |  | 06:00:00 | 10:05:00 |  | 06:00:00 | 07:34:00
 | Break #1 ~20m |  |  | Break #1 ~20m |  |  |  | Break #1 ~20m |  |  | Break #1 ~20m
 |  | 11:15:00 |  |  | 07:36:00 |  |  |  | 11:15:00 |  |  | 07:36:00
 | Work #2 < 5H |  |  | Work #2 < 5H |  |  |  | Work #2 < 5H |  |  | Work #2 < 5H
 |  |  |  |  | 10:09:00 |  |  |  |  |  |  | 10:09:00
 | Break #2 ~20m |  |  | Break #2 ~20m |  |  |  | Break #2 ~20m |  |  | Break #2 ~20m
 |  |  |  |  | 10:19:00 |  |  |  |  |  |  | 10:19:00
 | Work #3 < 5H |  |  | Work #3 < 5H |  |  |  | Work #3 < 5H |  |  | Work #3 < 5H
 |  |  |  |  | 16:26:00 |  |  |  |  |  |  | 16:26:00
 | Break #3 ~20m |  |  | Break #3 ~20m |  |  |  | Break #3 ~20m |  |  | Break #3 ~20m
 | Work #4 < 5H |  |  | Work #4 < 5H |  |  |  | Work #4 < 5H |  |  | Work #4 < 5H
 | Break #4 ~20m |  |  | Break #4 ~20m |  |  |  | Break #4 ~20m |  |  | Break #4 ~20m
 | Work #5 < 5H |  |  | Work #5 < 5H |  |  |  | Work #5 < 5H |  |  | Work #5 < 5H
 |  |  |  | 16:40:00 | 19:49:00 |  |  |  |  |  | 16:40:00 | 19:49:00
 | Break #5 ~20m |  |  | Break #5 ~20m |  |  |  | Break #5 ~20m |  |  | Break #5 ~20m
 | Work #6 < 5H |  |  | Work #6 < 5H |  |  |  | Work #6 < 5H |  |  | Work #6 < 5H
 | Break #6 ~20m |  |  | Break #6 ~20m |  |  |  | Break #6 ~20m |  |  | Break #6 ~20m
 | Work #7 < 5H |  |  | Work #7 < 5H |  |  |  | Work #7 < 5H |  |  | Work #7 < 5H
 | Break #7 ~20m |  |  | Break #7 ~20m |  |  |  | Break #7 ~20m |  |  | Break #7 ~20m
 | Mt Magnet Fuel |  |  | Mt Magnet Fuel |  |  |  | Mt Magnet Fuel |  |  | Mt Magnet Fuel
 | 10:07:00 | 10:21:00 |  | 10:07:00 | 10:21:00 |  |  | 10:07:00 | 10:21:00 |  | 10:07:00 | 10:21:00
 | [NAME] |  |  | Onsite @ Port or Shed |  |  |  | [NAME] |  |  | Onsite @ Port or Shed
 | 16:24:00 | 16:40:00 |  | 16:24:00 | 16:40:00 |  |  | 16:24:00 | 16:40:00 |  | 16:24:00 | 16:40:00
 | Loading |  |  | UnLoading |  |  |  | Loading |  |  | UnLoading
 | 16:26:00 | 16:38:00 |  | 16:26:00 | 16:38:00 |  |  | 16:26:00 | 16:38:00 |  | 16:26:00 | 16:38:00
 | O/N Break |  |  | O/N Break |  |  |  | O/N Break |  |  | O/N Break
 | 19:49:00 | 02:01:00 |  | 19:49:00 | 04:01:00 |  |  | 19:49:00 | 02:01:00 |  | 19:49:00 | 04:01:00