| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
converting numbers to time
I have a list of numbers:
900 1030 830 etc. I need these in the format: 09:00:00 10:30:00 08:30:00 etc I have tried text to columns but without the 0 before 830 the fixed width line doesnt fall right. Very stuck on this so any help would be gratefully recieved (otherwise I have alot of work on my hands!!) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Standard Time to Military Time in Excel | Excel Discussion (Misc queries) | |||
| formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
| Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
| Converting Numbers to Time | Excel Worksheet Functions | |||
| Converting time to numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
