View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jaybird
 
Posts: n/a
Default Importing Formatted Data

Howdy, folks...

Here's a sample of the payroll info we get. How can I import it into excel
in an orderly way? All I need is the name and the in and out times. How do
I get Excel to import only the data I need?

Jojo, Sparks 123456 131204 88888888 700 101092770
ID IN DEP Cus Fun ACTIVITY OUT ID IN DEP
Cus Fun ACTIVITY OUT TOTALS
Mon 03/20 645a*U 1132a M 1200p*S
341p 8.50 8.50
Tue 03/21 649a*U 1124a M 1152a*S
330p 8.20 16.70
Wed 03/22 653a*U 1129a M 1137a*S
341p 8.30 25.00
Thu 03/23 647a*U 1135a M 1202p*S
341p 8.40 33.40
Fri 03/24 653a*U 1141a M 1155a*S
330p 8.10 41.50*U
Sat 03/25 Unscheduled

Sun 03/26 Unscheduled


Acct:131204 88888888 700
Regular: 40.00 OverTime: 1.50 TOTALS:
41.50