| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number to time
Even shorter, Rick !! <bg
Pete On Mar 5, 7:03*pm, "Rick Rothstein \(MVP - VB\)" wrote: Thanks Biff this worked perfect, Petes solution worked also, two different ways of doing the same thing, never came across Biffs way of doing this before so will use this solution While it doesn't harm anything, Biff's formula has an extraneous set of parentheses in it. This version of it will work just as well... =--TEXT(A1,"00\:00") Rick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number to time | Excel Worksheet Functions | |||
| time into a number | Excel Discussion (Misc queries) | |||
| Every time i put a number with period it becomes a date and time | Excel Discussion (Misc queries) | |||
| Time as number | Excel Discussion (Misc queries) | |||
| Time to number | Excel Worksheet Functions | |||
Threaded Mode
