Need a Macro to change hhhh:mm:ss (BT format) to hh:mm:ss

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

Guest

British Telecom use hhhh:mm:ss as time format in downloaded bills, which
Excel 97 does not recognise. It can be converted to Excel by deleting two
leading "h"s. I've tried to make a macro but, if (eg) I convert 10 times and
then run the macro for the next ten, I just get the first ten repeated.
 
I'd suggest asking this in a newsgroup related to Excel.

This newsgroup is for questions about using macros in Access, the database
product that's part of Office Professional.
 
Back
Top