Home · Maps · About
Home > SubChat
 

[ Read Responses | Post a New Response | Return to the Index ]
[ First in Thread | Next in Thread ]

 

view flat

Re: Excel

Posted by BusRider on Sat Dec 9 13:41:47 2017, in response to Re: Excel, posted by Bill West on Sat Dec 9 02:26:16 2017.

Mr. West, Thank you for your efforts with assisting me first and foremost. Being you are helping me, I wanted to give you the information as we go as this is appears a time consuming and complicated task that I'm working on.

I changed the formula in cell F26 to "FLOOR" instead of CEILING. Using the four examples that I have in front of me, FLOOR came out with the appropriate OT figure for each example. I also, altered the formulas in both cells F24/26 to include MROUND.

Now to throw a wrench in your hard work, the payroll ST in cell F24 is either 7.25, 7.5, 7.75 or 8. With the numbers we used it comes out correct 8 ST 4.25. However when I change the times as example:

arrival 6:54am
commence work 7:04am
start break 11:10am
end break 2:34pm
finish day 7:35pm

The formulas come out to ST 8 OT 1.5 instead of ST 7.75 OT 1.5.
Please note as well 7.25 is the lowest so anything below 7h07 would be 7.25 ST.

To answer your questions:

1)No, for a 6:55 start it would be 7.25 ST and 3.75 OT.

2)8hrs ST and 2hrs OT rate.

3)If I understood you correctly your saying:
arrival 5:00am
commence work 5:10am
start break 7:50am
end break 4:00pm
finish day 7:10pm
Yes it does show as 3 ST and 3 OT (cells F23/F25). According to your formula it is shown as 8 ST and 3 OT (F24/F26).

4)For the sake of your question, based on the 7.25 pay guarantee for splits and 8 hour work guarantee for all, I would say it would be 7.25 ST and 3 OT. However, operationally speaking in transit, this would not be an actual work shift being its only 5h20 in total. Ideally, I would say both shifts (or pieces) of work would be individual trippers used as additional OT for regular run operators.

5)Fixed, unless its a road relief, then there is none it would be the same time as commence work.

Responses

Post a New Response

Your Handle:

Your Password:

E-Mail Address:

Subject:

Message:



Before posting.. think twice!


[ Return to the Message Index ]