| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
number to time format when digit length varies
I am struggling to convert following "number" format cells as 24 hrs "time"
format (hh:mm) 516 2306 637 202 2353 300 3 6 It should then appear as: 05:16 23:06 06:37 02:02 23:53 03:00 00:03 00:06 Any help will be a great relief. Thanks/regards, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Format on 16 Digit Number | Excel Discussion (Misc queries) | |||
| Length of time from date/time custom format | Excel Discussion (Misc queries) | |||
| how to format cell in excel for 12 digit number starting with a 0 | Excel Discussion (Misc queries) | |||
| Find character when the length varies | Excel Discussion (Misc queries) | |||
| How do i format a 5 to 6 digit number into the correct date? | Excel Worksheet Functions | |||
Threaded Mode
