| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Time to a Number
Hello,
I used the following formula to convert time to a number: =CONVERT(P14*24,"hr","mn") This works perfectly for some time, then I will open the spreadsheet and will receive a "Data Loss" error. When I open the spreadsheet, the cell will then have the following: =#N/A Any help is appreciated. Connie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting number to time | Excel Discussion (Misc queries) | |||
| Converting a decimal number into time | Excel Discussion (Misc queries) | |||
| converting a number to time | Excel Worksheet Functions | |||
| Converting a calculated number into time | New Users to Excel | |||
| Converting whole number to TIME | Excel Discussion (Misc queries) | |||
Threaded Mode
