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