newbieVBAwriter
New Member
- Joined
- Jun 11, 2013
- Messages
- 2
Hey there!
So I'm relatively new to VBA and I was wondering if there was a way to write a code that would see two columns, each with a date and a time in their respective column (ex. -> 6/7/2013 5:50:00), and determine the amount of hours that had passed between the two dates/times. It would basically be an hours counter, but I would only want to count the hours between when we are operating (M-F 7am to 8pm).
I was thinking that there would be an if statement that would determine if the company was open at that time, and then go from there. I figured this would be the best place for me to research this but I couldn't really find anything that would apply directly to my spreadsheet. Also, it is Excel 2003.
Thank you, I really appreciate your help.
So I'm relatively new to VBA and I was wondering if there was a way to write a code that would see two columns, each with a date and a time in their respective column (ex. -> 6/7/2013 5:50:00), and determine the amount of hours that had passed between the two dates/times. It would basically be an hours counter, but I would only want to count the hours between when we are operating (M-F 7am to 8pm).
I was thinking that there would be an if statement that would determine if the company was open at that time, and then go from there. I figured this would be the best place for me to research this but I couldn't really find anything that would apply directly to my spreadsheet. Also, it is Excel 2003.
Thank you, I really appreciate your help.
