ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Couple of Questions Need Help Please..... (https://www.excelbanter.com/excel-discussion-misc-queries/176086-couple-questions-need-help-please.html)

Jeremy

Couple of Questions Need Help Please.....
 
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?




All times are GMT +1. The time now is 09:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com