timesheet help please

**texmd** · 12-04-2012, 02:28 PM

I'm trying to run a spreadsheet for an employee recently terminated for lying on the timesheets. The computer log in and out record is available to me so I can actually see when this person logged in and out of the computor daily. Now the police want a spreadsheet with data like this: column A date, column B log in time [i use 2400 military]; column C log out time, Column D total time logged on to computer; column E computer idle time [it tells me if its been idle for over 30 min I have no idea how], column F would be D-E somehow to display the actual working time on said computer, column G is time stated worked ie total time that day the employee claims to have been working for me; and finally column H would be F - G to look at fraudulent hours. I am not a computer spreadsheet user and I've looked everywhere for this info. Please direct me to a solved forum entry or tell me how to set this up please.

**dogberry** · 12-04-2012, 02:35 PM

Hi

The computer log in/out register available to you is it possible to save that log and in what format can it be saved ie CSV file etc.

Chris

**texmd** · 12-05-2012, 06:21 PM

It downloads to PDF only.

**texmd** · 12-05-2012, 06:23 PM

I am having to look at timesheets which are paper, the log record which is PDF, and put the numbers into Excel so I was hoping to have it calculate the totals for me just to speed up this lengthy and very time consuming process. Any help is appreciated.

**dogberry** · 12-06-2012, 02:47 AM

Hi

Save your PDF as a text file and import into excel. Post a sample worksheet without any confidential information for us to have a look at.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Chris