ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I use the timecard template if I am using a time clock and. (https://www.excelbanter.com/new-users-excel/17180-how-do-i-use-timecard-template-if-i-am-using-time-clock.html)

Gargi Upadhyaya

How do I use the timecard template if I am using a time clock and.
 
I need help using the time card template in Microsoft Excel We use a time
clock and the employees punch the card when the come in and when they leave
in the evening. I would like to set iup the template. HELP!!!
Thanks ,
Gargi

JulieD

Hi Gargi

what i've not sure about is how the information gets from the card to the
excel spreadsheet - are you going to retype it? if so what assistance do you
need in setting up the spreadsheet beyond
...............A.......................B.......... ...........C........................D............. .......E
1.........Employee
#............Date............Start...............F inish...............Total
Time
2................................................. .................................................. ......=D1-C1

Cheers
JulieD

"Gargi Upadhyaya" <Gargi wrote in
message ...
I need help using the time card template in Microsoft Excel We use a time
clock and the employees punch the card when the come in and when they
leave
in the evening. I would like to set iup the template. HELP!!!
Thanks ,
Gargi





All times are GMT +1. The time now is 08:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com