Import .txt files into XL with time fields-need to calculate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Importing a .txt file with time fields and number fields. I have 2 goals
1) Must conditionally format fields containing times outside a range of 5 mintes before or 5 minutes after a certain beginning or ending time
2) Must review multiple time entries for 1 person and have a formula grab the earliest time for one field and the latest time for another field. Must then apply the conditional format to these as well

Any ideas would be appreciated. Haven't been able to find anything in MS Help or other print resources.
 
Hi
do you want to apply the conditional format after the import and if yes
can you give some example rows (post it as plain text) for your data.
Setting up some formulas for the conditional format should then be
quite straight-forward
Maybe you can explain your espected result with some examples
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Import .txt file error 1004 5
Possible to import Word forms en masse into Excel spreadsheet? 2
Import txt file via makro 2
Which Excel event to call when opening a .txt file 1
Importing TXT file into Memo Field 1
Incorrect date format when opening txt or csv files via macro 1
script to import parts of txt file 1
Importing Text File into Excel loses leading zero on some fields. 4

Back
Top