Contents of row deleted based on a zero value

[marcidee]

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


[TABLE="width: 754"]
<tbody>[TR]
[TD]Days Worked[/TD]
[TD]Start time[/TD]
[TD]Finish Time[/TD]
[TD]Time Worked[/TD]
[TD][/TD]
[TD]Breaks Yes/No[/TD]
[TD]Breaks From[/TD]
[TD]Breaks To[/TD]
[TD]Total Breaks[/TD]
[TD][/TD]
[TD]Total Time Worked[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mon 22 July 19[/TD]
[TD]10:00[/TD]
[TD]14:15[/TD]
[TD]04:15[/TD]
[TD][/TD]
[TD]No[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]00:00[/TD]
[TD][/TD]
[TD]04:15[/TD]
[/TR]
[TR]
[TD]Sat 00 January 00[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]00:00[/TD]
[TD][/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]00:00[/TD]
[TD][/TD]
[TD]00:00[/TD]
[/TR]
[TR]
[TD]Sat 00 January 00[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]00:00[/TD]
[TD][/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]00:00[/TD]
[TD][/TD]
[TD]00:00[/TD]
[/TR]
[TR]
[TD]Thu 25 July 19[/TD]
[TD]10:00[/TD]
[TD]18:00[/TD]
[TD]08:00[/TD]
[TD][/TD]
[TD]Yes[/TD]
[TD]12:00[/TD]
[TD]12:30[/TD]
[TD]00:30[/TD]
[TD][/TD]
[TD]07:30[/TD]
[/TR]
[TR]
[TD]Sat 00 January 00[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]00:00[/TD]
[TD][/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]00:00[/TD]
[TD][/TD]
[TD]00:00[/TD]
[/TR]
[TR]
[TD]Sat 27 July 19[/TD]
[TD]10:00[/TD]
[TD]18:00[/TD]
[TD]08:00[/TD]
[TD][/TD]
[TD]Yes[/TD]
[TD]12:00[/TD]
[TD]12:30[/TD]
[TD]00:30[/TD]
[TD][/TD]
[TD]07:30[/TD]
[/TR]
[TR]
[TD]Sun 28 July 19[/TD]
[TD]08:30[/TD]
[TD]20:30[/TD]
[TD]12:00[/TD]
[TD][/TD]
[TD]Yes[/TD]
[TD]12:00[/TD]
[TD]13:30[/TD]
[TD]01:30[/TD]
[TD][/TD]
[TD]10:30[/TD]
[/TR]
</tbody>[/TABLE]

 

[marcidee]

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