Newbie question

[zico60]

I have a timesheet for work where I put total hours in A1.Then i need a formula in B1 to calculate ordinary hours i.e 8.
And in C1 I will have 50% overtime i.e hours between 8-12.And at last in D1 all 100% overtime hours over 12.
Thanks for any help.

 

[russell_piper]

Check out ozgrid.com there are some good examples there, the one you want is called overtime.zip (I think) if not have a look. You will be able to incorporate what is displayed there into your own sheet

 

[Brian from Maui]

I used $10 as the base pay...cheap labor!

Book1
	A	B	C	D
1	9		135.00
2	7	70.00
3	13			260.00
4	11		165.00
Sheet1

This message was edited by Brian from Maui on 2002-08-29 06:57

 

[cblincoln43]

Need e-mail address. Will send you a version of my sheet (just completed) Thanks to all the NEET people on MrExcel. board. Take Note: There are three deferant ways to calculate time for these time sheets. 1. Normal 2. Floor 3. Ceiling. The last two will brake down time to Tenths or Hundredths and One Rounds Time Up. One does not. The Formula I used in my hourly break down was Thanks to Aladin Akyurek,quite a wile back. You can SEARCH this site for cblincoln43,to find it if you are not sure about sending me your e-mail address.
Bob, Cblincoln43@yahoo.com

NO way to Thank The Board enough for All their Help and Knowlage. Special Thanks to
ALADIN AKYUREK and MARK W.mvp
Edit: This Time Thing An't Easy,even after you have the formulas to work with.
This message was edited by cblincoln43 on 2002-08-30 19:17