Contents of row deleted based on a zero value

marcidee

Board Regular
Joined
May 23, 2016
Messages
155
Please can someone help me with a script - I have a table 11 columns (D to N) and 7 Rows (Rows 7 to 13) - I would like the contents of each row removed if the value in G = 00:00


Days WorkedStart timeFinish TimeTime WorkedBreaks Yes/NoBreaks FromBreaks ToTotal BreaksTotal Time Worked
Mon 22 July 1910:0014:1504:15No0000:0004:15
Sat 00 January 000000:0000000:0000:00
Sat 00 January 000000:0000000:0000:00
Thu 25 July 1910:0018:0008:00Yes12:0012:3000:3007:30
Sat 00 January 000000:0000000:0000:00
Sat 27 July 1910:0018:0008:00Yes12:0012:3000:3007:30
Sun 28 July 1908:3020:3012:00Yes12:0013:3001:3010:30

<tbody>
</tbody>
 

marcidee

Board Regular
Joined
May 23, 2016
Messages
155
To summarise for example if G7 = 00:00 then D7 to N7 is empty (or if it's easier it could be if N7 = 00:00)

Still looking for help with this if possible
 

Forum statistics

Threads
1,082,588
Messages
5,366,490
Members
400,895
Latest member
shumcal

Some videos you may like

This Week's Hot Topics

Top