LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to avoid date convertions when importing external web data? Cokeat Excel Discussion (Misc queries) 1 January 10th 06 09:16 PM
Importing Data from Access Jon_h2 Excel Discussion (Misc queries) 2 October 14th 05 11:15 AM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM
IMPORTING TEXT DATA Bill C Excel Discussion (Misc queries) 1 May 12th 05 10:05 AM


All times are GMT +1. The time now is 02:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"