Importing to Excel Worksheet
Project ID:
105099
Project Type:
Fixed
Budget:
$30-$100 USD
Project Description:
have a tab delimited file that needs to be imported into an Excel Worksheet.
It should not take someone who knows VB well much time to complete.
The data file is from an employee time clock that students use to track their attendance. The file logs the date and time they are in classs. The data needs to be imported into an Excel Worksheet that tracks the number of hours they are attending per day for the month. All students for the month are displayed on the worksheet with the dates of the month at the top. The days where the students have no hours then tells the instructor that the student was absent.
txt file format:
stdId,stdName,timeIn,timeOut,totalTime
Excel Worksheet Format:
stdID,stdName,day1,day2,...,day30
Skills required:
Visual Basic
Public Clarification Board
0 messages