Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Convert hhhh:mm:ss to hh:mm:ss (macro ?)
British Telecom use hhhh:mm:ss as a time format for length of call in downloaded accounts. Excel97 does not recognise this as a number so I cannot reformat to hh:mm:ss. I've tried (with no experience) a macro to remove the 2 leading zeros, but if I set it up by converting the first 10 times, then try to run it starting at the 11th time, it does not convert the second set of ten, but simply replicates the times created (for the first ten) when setting up the macro. BT Bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
automatic macro update | Excel Worksheet Functions | |||
Date macro | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Macro Formula revision? | Excel Worksheet Functions |