Macro for Br.Telecom a/c

G

Guest

BT use hhhh:mm:ss as time format in downloaded bills, which Excel does not
recognise. It can be changed to recognisable format by deleting two h's. When
I made a macro to do this using the first 10 entries, and then applied the
macro to the second 10, it just replicated the figures in the first 10.
 
B

Bob Phillips

Change the time format to [hh]:mm:ss

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Training on macros in Excel97 using Windows 98 1
Convert hhhh:mm:ss to hh:mm:ss (macro ?) 1
Need a Macro to change hhhh:mm:ss (BT format) to hh:mm:ss 1
Totalling time quantities 2
Conditional formatting on a dynamic range - workaround 1
Can't access memory stick 6
wnat to extract first & last names in sep cols from name list in 1 4
Count entries in the column translating to minutes. 5

Top