Contents of row deleted based on a zero value

marcidee

Board Regular
Joined
May 23, 2016
Messages
184
Office Version
  1. 2019
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>
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
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
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,140
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top