Automating Timesheet.

[Nuttie10]

I need help automating this time sheet.
I just want to insert in time and out time.
Attached is an example of a Sunday timesheet.
There is only one unpaid break between 1230 and 1300. Normal time is 0730 to 2000 on weekdays.All of Saturday is overtime and all of Sunday is double time.
Hope someone can help with this problem.

[arthurbr]

Have you searched the forum? This has been asked and solved many times

[Nuttie10]

i have searched the forum but cannot find what i'm looking for. Maybe i have'nt searched long enough, unfortunately i dont have time to look any more. i start at 07h00 in the morning and finnish at between 19h00 and 22h00 every day, seven days a week and have to keep track of about 35 guys. The example attached in only one of a few timesheets i have to do daily to get sighned off by site engineers. Please i'm DESPERATE.

[Nuttie10]

Arthurbr, if you could be so kind as to point me to a solved problem like mine i would greatly appreciate it.

[arthurbr]

I have added an answer ( yellow and orange hihghlight) for two possibilities ( not necessarily on overtime days) (see attached)

But, you should first change your sheet and format cells as needed.

F.I the In and OUT cells are text

before entering time, format those columns astime then enter hh:mm NOT hhmm. That makes things difficult to work with

If you have other problems don't hesitate to post back

Also check this link : http://www.excelforum.com/excel-gene...e-formula.html

Or this one http://www.meadinkent.co.uk/excel-shifts.htm

[Nuttie10]

Thanks Arthurbr
I'm starting to read up on Excel formulaes and VBA in a hope that i will one day be able to help others like you are doing now. Any sugestions on reading material that would help. Could you please help me understand how this formula works and why does it show all ##### when i input a time after 08:00 pm in the in time in the orange row? Is it possible to enter the time without having to manually insert the colons? Many thanks in advance.

[arthurbr]

I'll have to come back to you on this one

[Nuttie10]

Thanks
I'll be reading up on formulas in the meantime.

[arthurbr]

I think the attached should cover your needs.
You can enter start and end time with the drop down boxes in col D and E

Use the sheet as a template for other days, just enter the date in B2.

I have adapted the times in the colored zone. Feel free to test the rest

[Nuttie10]

Thank You so very much Arthurbr,
You a superstar. Better than this is wrong.

[arthurbr]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[Nuttie10]

can someone tell me how to mark a post as solved.

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[Nuttie10]

Hi arthurbr
i am so sorry to bother you again, i was going thru your timesheet and discovered that i someone works on a Saturday into sunday the time is not split between overtime and double time and the same goes for Sunday into Monday, double time and overtime.
Hope you can help.