Employee's Workhours and Overtime Pay

[famieshafie]

I am preparing a worksheet that will calculate a worker's normal working hours and overtime working hours.

The value in A1 minus B1 will show result in C1 and D1

If the result form A1 minus B1 exceeds 8, the value 8 will go show in C1 and the remaining value shows up in D1.

For example: 12 is the result of A1 minus B1. So, C1 will display the number 8 and 4 will display in D1.

How can I do that...?

 

[Taul]

sorry, I haven't tried to answer your question but there are so many time sheets out there, just google it

http://spreadsheetpage.com/index.php/file/employee_time_sheet/

 

[famieshafie]

Dear Paul,

I am new to excel and googling does help when it directed me to MrExcel. That you for the link you gave me, I'll try my best to read thru the content till I find the answer... and I hope it will be soon, my boss is pushing.

Thank you.

 

[cgcamal]

Hi, this could works for your request: in C1 =IF(B1-A1>8,8,B1-A1), In D1: =IF(B1-A1>8,B1-A1-8,"") Now only copy down up to row you need. I hope this helps. Best regards

 

[famieshafie]

Hi, this could works for your request: in C1 =IF(B1-A1>8,8,B1-A1), In D1: =IF(B1-A1>8,B1-A1-8,"") Now only copy down up to row you need. I hope this helps. Best regards

Hey Cesar,

It gave me result in both C & D as what I needed... I will do the adjustment from there.. I would like to thank you for your kind assistance.

 

[cgcamal]

Your welcome Famie, I^ve realized of one thing; replace "B1-A1" and put in its place "A1-B1" in all occurences in both formulas. Or use absolute value formula within IF formula to get always a positive result. E.g. "IF(ABS(B1-A1),...). Best regards