I am trying to create a timecard workbook in Excel. My problems are that

#1. I am a beginner with Excel.

#2. I cannot find a workbook online that has multiple sign in/sign outs in one day and I do not yet understand all of the formulas.I work in an office that has service technicians and I need to enter their daily time in per job. They can do up to 8 different jobs a day.

Can anyone help me with this?

re: "I cannot find a workbook online that has multiple sign in/sign outs in one day"I'm not sure what search terms you used, but I had no problem finding timesheet templates with multiple sign-in times.

One such example:

http://www.vertex42.com/ExcelTempla...

Description from website:

Timesheet with 2 Breaks

This version allows you to include up to 2 breaks per day (or in other words, 3 separate clock in/out times).The following page offers step by step instructions for creating your own time card templates, including the required formulas.

http://www.techrepublic.com/blog/wi...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History