Help counting hours in VBA

Hello WarWabbit,

Welcome to the Forum!

Do the times start in column "G"?

What is the starting row?

Hello WarWabbit,

The macro will replace the times in columns G - M with the hours, correct?

So, 11am - 3pm would become 5 or would it be 5 hours?

Hi,
It won't actually change the cell value, it will leave them as a string so the user can see the shift that has been input, the vba code captures the daily hours which I can then output as a day or as the whole week, which is what I need. It's the ability to strip the hours of a day into the appropriate times. So with a 12pm - 3pm shift I need to be able to output that 1 hour has been worked at 12pm, 1pm and 2pm. If it's easier I can link you the file if there is a way to do that?

Cheers,
~Wabbit

Posted twice, please delete.

You can post a copy of the workbook here at the forum.

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Hello WarWabbit,

I rewrote the UDF. It is much shorter and recalculates whenever a change is made to a dependent cell. All of the =Hours() UDF calls have been replaced with the new UDF call =CalculateHours()

Module2 UDF Macro Code

Please Login or Register  to view this content.

Hello WarWabbit,

I cleaned the code up a little. This removes some unnecessary redundancy.

Improved UDF Code

Please Login or Register  to view this content.