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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BT BILL - 27 Feb 2005 07:59 GMT

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.

Reply to this Message

Douglas J. Steele - 27 Feb 2005 12:10 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> 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.

Reply to this Message