# Newbie question

#### zico60

##### New Member
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.

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
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

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
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

Replies
22
Views
545
Replies
1
Views
821
Replies
5
Views
418
Replies
7
Views
1K
Replies
3
Views
609

1,219,798
Messages
6,150,318
Members
450,951
Latest member
kh198

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back