How do I select a constant time range from a variable time range using VBA 
Author Message
 How do I select a constant time range from a variable time range using VBA

Hi All :-)

Can some one please offer some VBA help regarding the
following:

I am trying calculate employee earnings based on a
variable pay rate structure within a 24hr period. That is,
the employee pay rate e.g. Flat Rate, Time Plus Half,
Double Time etc varies according to the time of day
worked.

The actual hours submitted by the employee are however
specified within a single time range. Example: Total hours
worked = 07:00:00 to 20:00:00 = 13 hours

The VBA code would need to split out the variable pay rate
based on the example above i.e. (07:00:00 to 20:00:00 = 13
hours) as follows:

*** Split out below assumes hourly pay of 10 ***

07:00:00 to 16:00:00 - Flat Rate i.e. 9hrs * 10
16:00:00 to 00:00:00 - Time Plus Half i.e. 8hrs * 15
00:00:00 to 07:00:00 - Double Rate i.e. 7hrs * 20

Thus, the VBA code would determine that for hours
submitted by the employee, from 07:00:00 to 20:00:00
(13rs) ...



Thanks!



Mon, 11 Apr 2005 08:07:15 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. How Do I select a constant time range from a variable time range using VBA?

2. How do I select a constant time range from a variable time range using VBA?

3. VBA Range().Select expresssions using variables

4. adding a selected range into SELECT statement using VBA

5. VBA :Selecting ranges that vary, Naming ranges based on Formatting

6. Error when checking a variable against a Range when variable value not in the range

7. Selecting a variable range of cells in VBA

8. prompting user to select a range and using this range

9. Select cell using Range variable

10. Selecting Print range using a variable??


 
Powered by phpBB® Forum Software © phpBB Group