EXCEL MONTHLY TIMESHEET NIGHTMARE

[cuddlezuk]

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]

Perfect, just didn't know the 0545 formula so if earlier it is 0545, after it goes back to the 15 minute increments

 

[cuddlezuk]

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]

Done it, thanks working perfect again.

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

 

[Toadstool]

You're welcome!

 

[cuddlezuk]

You're welcome!

Employer getting tight, not paying for 45 min breaks when used to be 30, and if you come in early now they don't pay you for it