Solved Excel Timecard formula help!

May 28, 2015 at 09:18:00
Specs: Windows 8
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?


See More: Excel Timecard formula help!

Report •


#1
May 28, 2015 at 10:14:06
✔ Best Answer
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.


Report •
Related Solutions


Ask Question