Newbie question

zico60

New Member
Joined
Aug 28, 2002
Messages
1
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

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

russell_piper

Active Member
Joined
Jul 15, 2002
Messages
259
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
 

cblincoln43

Board Regular
Joined
Mar 12, 2002
Messages
206
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
 

Forum statistics

Threads
1,148,526
Messages
5,747,216
Members
424,069
Latest member
kamkwok1hh

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top