EXCEL MONTHLY TIMESHEET NIGHTMARE

cuddlezuk

Board Regular
Joined
Aug 29, 2020
Messages
58
Office Version
  1. 2019
Platform
  1. Windows
I've been trying to make a timesheet for my work, so my overtime gets paid to me.

Looking for a monthly timesheet starting 20th of every month to the 19th.

Monday to Thursday, but paid in 15 minute intervals, so if I clock in at 0520, I get paid from 0530, if I clock out at 1720, I get paid to 1715. as the round it back if before clock out early, and round it forward if I clock in early.

So a time sheet, with Day, Date, Start Time, 30 Min Break deduction, Finish Time, Showing my 10 hrs normal time with the break, anything over is overtime, so 10hrs 30mins normal, as they deduct the break,

At the bottom, total hours worked, plus total overtime at the bottom?

I can't get it myself, tried, tried and tried, without any success.
Can you get 24hr clock displayed, so start time 0520 and 1730 end time ?

Any chance you can throw one together, so I can tweak it if needed?
 

cuddlezuk

Board Regular
Joined
Aug 29, 2020
Messages
58
Office Version
  1. 2019
Platform
  1. Windows
Perfect, just didn't know the 0545 formula so if earlier it is 0545, after it goes back to the 15 minute increments
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

cuddlezuk

Board Regular
Joined
Aug 29, 2020
Messages
58
Office Version
  1. 2019
Platform
  1. Windows
Is there a way to paste formulas, but the cells remaine the original number, so paste the formula into C4,C5, etc so formula goes into each cell but cell letter doesn't change from original
 

cuddlezuk

Board Regular
Joined
Aug 29, 2020
Messages
58
Office Version
  1. 2019
Platform
  1. Windows
Done it, thanks working perfect again.

Thanks again for your help!! It's very much appreciated!
 

Forum statistics

Threads
1,144,611
Messages
5,725,308
Members
422,608
Latest member
bswg5882

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