Contents of row deleted based on a zero value

marcidee

Board Regular
Joined
May 23, 2016
Messages
159
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>
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

marcidee

Board Regular
Joined
May 23, 2016
Messages
159
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
 

Watch MrExcel Video

Forum statistics

Threads
1,099,390
Messages
5,468,322
Members
406,579
Latest member
lollypop1389

This Week's Hot Topics

Top