Sep 9, 2002 #1 ryan101 Programmer Jul 11, 2001 13 US I've got strings of numbers like: a = 4 b = 416 c = 723 d = 1534 I want to be able to convert these numbers into time format so that a = 12:04am b = 4:16am c = 7:23am d = 3:34pm Anyone know of a quick and painless method?
I've got strings of numbers like: a = 4 b = 416 c = 723 d = 1534 I want to be able to convert these numbers into time format so that a = 12:04am b = 4:16am c = 7:23am d = 3:34pm Anyone know of a quick and painless method?
Sep 9, 2002 #2 sfvb Programmer Nov 25, 2001 399 US a = CDate(TimeSerial(int(a/100), a mod 100, 0)) b = CDate(TimeSerial(int(b/100), b mod 100, 0)) ... Upvote 0 Downvote