1. I need to create a macro to insert a row when the data in column G
changes from ZA to ZB. I am not good at inputting stuff into the VBA part of
Excel, so I would need this spelled out for me.

2. I also need to know if there is a formula that will calculate the hours
elapsed between two dates and dimes. I can have the date and time in one
cell or 2, but I keep getting the wrong info. I need to count business days
only, but they need to be a full 24 hour day. What would work best?