x1.5

  1. B

    Seperating hours from a range of time.

    Hello All, I have in the past found loads of help from other posts on this site, but I am a bit stumped now. I am trying to create a timesheet that can calculate a shift whether that be a day shift or a night shift that spans midnight. Giving the total hours (this is the easy bit for me)...
  2. B

    separating OT hours from total hours

    I have a column H13:H each cell in the column represents the total hours worked that day, I am trying to come up with a formula where 9 hours of every day will be regular hours and all hours after 9 will be multiplied by X1.5. I currently have Total=396 hours Regular=258 OT=138 x1.5 =207...
  3. P

    If formula help!

    HI I have the following formula: =IFERROR(IF(O2="Sun","Overtime X2",IF(O2="Sat",LOOKUP(U2,{0,"08:00","12:01"}+0,{#N/A,"Overtime X1.5","Overtime X2"}),LOOKUP(U2,{0,"17:31","23:59"}+0,{"Overtime X2",#N/A,"Overtime X1.5"}))),M2) This formula works great for the "Sat" and "Sun" criteria, it...

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