counting # of hours worked for premium pay, when hours vary

July 28, 2012 at 20:16:37
Specs: Windows XP, Pentium 4/2gb ram
Payroll; random hrs worked, need calc #hrs premium time. Drivers take buses out at all times around the clock. They get paid a fixed hourly wage. However, if any of their hours worked fall between 10pm and 6am the following day, in addition to their base hourly pay, they receive a $1 premium pay only for those hours in that premium time frame. Any suggestions for counting the number of hours worked during the premium time frame? Thanks, Dan

See More: counting # of hours worked for premium pay, when hours vary

Report •

#1
July 28, 2012 at 20:37:17
In order to offer any assistance, we would need to know the layout of your spreadsheet.

If you could post an example of your data, that would help.

Please click on the following line and read the instructions on how to post data in this forum.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
July 28, 2012 at 23:38:38
Driver:   DAVID 								
			
Date   Co.	 start  stop  hrs   rate    amt      hrs            
06/29 MAT         16:00 0:30  8.50 $11.50  $97.75   8:30
			      2.50  $1.00   $2.50   0:00
06/30 MAT	   8:15 2:30 18.25 $11.50 $209.88  18:15
		              4.50  $1.00   $4.50   0:00
07/01 BRI         11:30 5:30 18.00 $11.50 $207.00  18:00
			      8.00  $1.00   $8.00   0:00
			       128.75	$1,250.51   0:00

Please note that everything is calculated, except the second line of the entries where the number of hours within the premium time (2nd line) are hand calculated. Unfortunately I can't provide the code as I don't know VBS.


Report •

#3
July 29, 2012 at 12:12:30
re: Unfortunately I can't provide the code as I don't know VBS.

What do you mean by this?

VBS typically stands for Visual Basic Script, which has nothing to do with Excel.

If you meant VBA (Visual Basic for Applications) which can be used in an Excel environment, I still don't understand how it is associated with your question.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
July 29, 2012 at 17:42:33
Sorry, I misunderstood. The example that I was pointed to showed both a sample of a spreadsheet, and a sample of VBA code to be provided. I mistakenly thought that I needed to provide the VBA code, and I know nothing of how to do this.

The only thing I had was the spreadsheet provided above. Is that sufficient to answer the initial question?


Report •

Ask Question