work hours counting formula

**adamek174** · 09-20-2012, 01:20 PM

hi maybe someone will be able to help me a bit :D a big bit...
i need a formula that counts hours at different rates from 16:00-04:00 10$ per hour and between 04:00-16:00 9$ per hour
example working from 9-21 so 7h for 9$ and 5 for 10$
20-8 so 8h for 10$ and 4 for 9$
if someone could help me with it please

**dilipandey** · 09-20-2012, 02:23 PM

Hi adamek174,

Welcome to the forum.

How your original data look like.. I am sure it'll not like 9-21 ??
Can you upload a sample workbook. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**adamek174** · 09-20-2012, 07:13 PM

it's any time to be honest i start different times every day, it can be 8.00, 14.00 or 03.00 i need it to count how many hours worked before 16.00 till 04.00 and the other way

**adamek174** · 09-20-2012, 07:26 PM

i was thinking something like this just i dont know how to make it into formula A1=9.00 A2=21.00
if A1 is between 04.00 and 16.00 than it would count how many hours it is and multiply by 9,5 + and count how many hours between 16.00 to 4.00 and multiply by 10.5. dont really know how to explain it better