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?

 

[Toadstool]

Changed the date, the bottom two days and dates not being displayed.

You should only enter data into the yellow fields but you've overwritten the date formula.

 

[cuddlezuk]

I formatted as above, not custom

 

[cuddlezuk]

The formula's are still there, but not showing

 

[cuddlezuk]

your calculation is wrong, if I start 0520, I get paid from 0515, if I start 0540 I get paid from 0530

 

[cuddlezuk]

clocking in, if I clock in at 0505 that counts as 0500, if I clock out at 1725, that counts as 1715, don't know if it' possible to calculate that.
or if I start 0440, thats 0430 paid from, clocking out 1658 would be 1645

 

[cuddlezuk]

I got the times fixed, just the day and date bottom two dates not being displayed

 

[cuddlezuk]

I've entered the formulas again for bottom two dates and still no date gets showed

 

[cuddlezuk]

Even your original version doesn't work for bottom two dates,

 

[cuddlezuk]

Disregard previous messages, had wrong start date in timesheet, put 19th to 20th, when it's 20th to 19th, sorry!

 

[cuddlezuk]

Last and final question, how can I get rid of the yellow background from clock in times?