| 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 |
| 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 | |||
![den748[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
