Board index mac

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

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

Post by QlQgQklMT » Mon, 28 Feb 2005 16:59:02


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

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

Post by Douglas J. » Mon, 28 Feb 2005 21:10:42

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.

--
Doug Steele, Microsoft Access MVP
http://www.yqcomputer.com/
(no e-mails, please!)

 
 
 
Top

1. Convert hhhh:mm:ss to hh:mm:ss (macro ?)

2. format MM:SS without mm/dd/yyyy/hh:mm:ss?

3. Date format changes from 'yyyy-mm-dd hh:mm:ss' to 'mm/dd/yyyy'

4. Convert 04:03:00 (hh:mm:ss) to 04:03 (mm:ss)

5. Change format to mm dd yyyy hh mm ss

6. hh:mm:ss.ss Number format

7. Charting Items in H:MM:SS format and/or converting H:MM:SS to all

8. Round hh:mm:ss to whole hh:mm

9. from hh:mm:ss to hh:mm ?

10. mm/dd/yyyy hh:mm:ss to mm/dd/yyyy

11. Date and Time (entering in the format of mm/dd/yyyy and hh:mm:ss )

12. DOS Command to display time in format - HH:MM:SS:MM

13. Getting DATE + Hour in YYYY-MM-DD HH:MM:SS:MSS Format

14. SAVEDATE Format dd/mm/yyyy hh:mm:ss

15. Convert a STRING "DD.MM.AAAA HH:MM:SS" to DATETIME format

All times are UTC
Board index