Using Macros to calculate employee hours on a schedule

**christhweatt** · 09-11-2013, 12:53 AM

Can someone help me? I'm trying to write a Macro that can search my spreadsheet for an employees name and calculate the number of hours on the schedule, but I don't know where to start...
For instance I have a range of cells (B57:B78) with all employee names. I would like the macro to go down the list until it finds a blank cell (end of the list) and calculate hours worked.
I have attached my schedule for a visual.
I also relize that I will have to go through and change names so they match the list.
Please let me know if you need any more details.

**arlu1201** · 11-20-2013, 05:21 AM

Sorry this is late, but maybe someone can benefit if the solution is shared.

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

Using Macros to calculate employee hours on a schedule

LinkBack

Thread Tools

Rate This Thread

Display

Using Macros to calculate employee hours on a schedule

Re: Using Macros to calculate employee hours on a schedule

Thread Information

Users Browsing this Thread

Similar Threads

Employee Schedule - Subtracting a 30 min lunch from a schedule 6 or more hours long

Employee schedule hours tracking

Find and calculate employee hours within date range

[SOLVED] Calculate employee hours for employee evaluation?

[SOLVED] Employee schedule: I want it to calculate time entered such as 11.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions