Breakdown of total daily worked hours

If you upload a sample sheet showing what you would like to see, it would be much easier, then we can reference our formulas to your data..
BUT, with that in mind, assuming data in column A, Starting with row 1
B1: (Reg Time):
=IF(A1>8,8,A1)
C1: (1.5):
=IF(A1>8,IF(A1<=10,A1-8,2)
D1: (2):
=(A1>10)*(A1-10)
E1: (Tea Time)
=(A1>=10)*(tea money calculation)

Hope this helps

Thats fine...hows tea money calculated?

Try these so far, when you get back to me with the "tea money" info I will add
G3:
=IF(F3>8,8,F3)
drag down

H3:
=IF(F3>8,IF(F3<=10,F3-8,2),0)
drag down

J3:
=(F3>10)*(F3-10)
drag down

and a suggestion for I3:
=(H3=2)*tea money amount
Drag down

Hope this helps

Hi, not sure if this will help, but I created this for another member. It is based on the following, maybe you cad adapt it to suite your needs?

weekday hours up to 8 = regular time
weekday hours 8 -10 = * 1.5
weekday hours > 10 = * 2
Sat hours up to 8 = * 1.5
Sat hours > 8 = * 2
Sun hours = * 2

To tell you the truth, that means absolutely nothing to me...show me how it works...what is the VALUE of TEA MONEY, how can I calculate it?...is it a true or false/yes or no/ owed or not owed??
Show mea on a worksheet, (And PLEASE use one of the options offered for the calculations...TO show me HOW it relates to the data, please !

Paysheet.beitzy.sol1.xlsSO...to get this straight---if they work at all--costs $25.00
if they work over 8,but less then10 hrs the "meal cost" is $37.50 for the DAY..not added to the $25.00?
if they work 10 hrs exactly, "mealcost" is $37.50+ $15.00 or $25.00+$15.00 (ie=$40.00)
if they work anything above 10 hrs $50.00 for the day?

need some solid information..(ie- IF they work 8hrs or less, meal cost is $25, if they work More than 8hrs but less than 10hrs meals cost $37.50, if they work 10hrs exactly meal cost is ??$40.00 or $52.50??, if they work 10+ hours meal costs is $50.00)

here's the attachment showing how i calculated the hour, I left meal time out as this is still completely un-understandable to me :Paysheet.beitzy.sol1.xls

(* BTW - remind me never to hire on with you, MY boss tried this with me, he'd be short a couple of crews for sure )

I want to help, but make what you want CLEAR,please

Try this :Paysheet.beitzy.sol2.xls
hope this helps

You are welcome

Please remember to mark the thread as solved if you are satisfied with your solution :
To mark thread "Solved", go to the top of the thread,click "Thread Tools",click "Mark as Solved"

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as "SOLVED".
For the meantime I'll do it for you.

How?
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Note:
You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.