I am repeating the question since I did not see it posted to the board.
I would like to create a time card sheet that has time in and time out, then caculate the number of hours worked (this I can do) then convert the mm to 1/4 hour increments i.e. 0 to 15 minutes = .25, 16 to 30 minutes = .5, 31 to 45 minutes = .75, 46 to 60 minutes = next whole hour.
Even better if we can incorporate the 8 minuite rule (7 min or less is rounded down and 8 min or greater is round up to the next 1/4 hour.
I will take the output of this function and multply by the pay rate to get gross pay.
Thanks for the help, Curt
This message was edited by c24c4 on 2002-06-01 06:01
I would like to create a time card sheet that has time in and time out, then caculate the number of hours worked (this I can do) then convert the mm to 1/4 hour increments i.e. 0 to 15 minutes = .25, 16 to 30 minutes = .5, 31 to 45 minutes = .75, 46 to 60 minutes = next whole hour.
Even better if we can incorporate the 8 minuite rule (7 min or less is rounded down and 8 min or greater is round up to the next 1/4 hour.
I will take the output of this function and multply by the pay rate to get gross pay.
Thanks for the help, Curt
This message was edited by c24c4 on 2002-06-01 06:01