Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting a number to a date/time
I need to make a program that turns a number in the form of ymmdd int
yy/mm/dd. I also have time in the format of hhmmss and need it in th form hh:mm:ss. I have tried various things in excel but was not abl to figure out how to convert it. Please help me. Here are som example numbers, 40106 (ymmdd) 145625 (hhmmss) Thank yo -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting a number to a date/time
Take a look at Chip Pearson's page
http://www.cpearson.com/excel/DateTimeEntry.htm -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "den748 " wrote in message ... I need to make a program that turns a number in the form of ymmdd into yy/mm/dd. I also have time in the format of hhmmss and need it in the form hh:mm:ss. I have tried various things in excel but was not able to figure out how to convert it. Please help me. Here are some example numbers, 40106 (ymmdd) 145625 (hhmmss) Thank you --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting text format of time/date into Excel time/date for subtr | Excel Worksheet Functions | |||
Converting time to number, i.e. 2:32 to 2.32 | Excel Worksheet Functions | |||
Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
converting number to time | Excel Discussion (Misc queries) | |||
converting a number to time | Excel Worksheet Functions |