Spreadsheet: 148554d1333465437-possible-to-not-display-a-formula-result-if-less-than-say-0-new-new-new-rota-version2
Sheet: new rota

[NAME] :
Job Title | Name |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday |  |  |  | Sunday |  |  | Scheduled | Contr
 |  |  | 8 - 10pm | L | H |  | 8 - 10pm | L | H |  | 8 - 10pm | L | H |  |  | L | H |  |  | L | H |  |  | L | H |  |  | L | H | Hours | Hours
Produce | [NAME] |  | 06:00:00 |  |  |  |  |  |  |  |  |  |  |  | 06:00:00 |  |  |  | 06:00:00 |  |  |  | 06:00:00 |  |  |  | 06:00:00
Manager |  |  | 16:00:00 | 0.5 |  |  |  |  |  |  |  |  |  |  | 16:00:00 | 0.5 |  |  | 16:00:00 | 0.5 |  |  | 16:00:00 | 0.5 |  |  | 16:00:00 | 0.5 |  |  | 43
 |  |  |  |  |  |  | DO |  |  |  | DO
Produce | [NAME] |  |  |  |  |  | 07:00:00 |  |  |  | 07:00:00 |  |  |  | 12:00:00 |  |  |  | 07:00:00 |  |  |  | 11:00:00
Supervisor |  |  |  |  |  |  | 17:00:00 | 1 |  |  | 17:00:00 | 1 |  |  | 21:00:00 | 1 |  |  | 16:00:00 | 1 |  |  | 17:00:00 | 1 |  |  |  |  |  |  | 39
 |  |  | DO
Produce | [NAME] |  | 12:00:00 |  |  |  | 08:00:00 |  |  |  | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  | 12:30:00 |  |  |  | 09:00:00
Sales | [NAME] |  | 21:00:00 | 1 |  |  | 17:00:00 | 1 |  |  | 17:00:00 | 1 |  |  |  |  |  |  |  |  |  |  | 21:30:00 | 1 |  |  | 18:00:00 | 1 |  |  | 39
Assistant |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DO |  |  |  | DO
Produce | [NAME]
Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39
Assistant |  |  | DO |  |  |  | DO |  |  |  | DO |  |  |  | DO |  |  |  | DO |  |  |  | DO |  |  |  | DO
Produce | [NAME]
Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39
Assistant
Produce | [NAME]
Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39
Assistant
Produce | [NAME] |  | 08:00:00 |  |  |  | 08:00:00
Sales |  |  | 17:00:00 | 1 |  |  | 17:00:00 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39
Assistant |  |  |  |  |  |  |  |  |  |  | DO |  |  |  |  |  |  |  |  |  |  |  | DO
Produce | [NAME] |  | 15:00:00 |  |  |  |  |  |  |  | 15:00:00 |  |  |  |  |  |  |  |  |  |  |  | 10:00:00
Sales |  |  | 22:00:00 |  |  |  |  |  |  |  | 22:00:00 |  |  |  |  |  |  |  |  |  |  |  | 17:30:00 | 1 |  |  |  |  |  |  | 20.5
Assistant
Produce | [NAME] |  | 1900-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:30:00 |  |  |  | 1900-01-01 00:00:00 |  |  |  | 1900-01-01 00:30:00 |  |  |  | 01:00:00
Night |  |  | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  | 08:00:00 |  |  |  | 08:00:00 |  |  |  | 08:00:00 |  |  |  | 09:00:00 |  |  |  | 39
Assistant |  |  |  |  |  |  | DO |  |  |  | DO
Produce | [NAME] |  |  |  |  |  | 1900-01-01 00:00:00 |  |  |  | 1900-01-01 00:00:00 |  |  |  | 1900-01-01 00:30:00 |  |  |  | 1900-01-01 00:00:00 |  |  |  | 1900-01-01 00:30:00
Night |  |  |  |  |  |  | 08:00:00 |  |  |  | 08:00:00 |  |  |  | 08:00:00 |  |  |  | 08:00:00 |  |  |  | 08:00:00 |  |  |  |  |  |  |  | 39
Assistant |  |  | DO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DO
Total | Daily Hours
Daily | Hours % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
Scheduled | By: |  |  |  |  |  |  |  |  | Checked By: |  |  |  |  |  |  |  |  |  |  |  |  | Approved By:
Department [NAME]: |  |  |  |  |  |  |  |  |  | Store Personnel Mgr : |  |  |  |  |  |  |  |  | Date: |  |  | Store General Mgr/Deputy: |  |  |  |  |  |  | Date: