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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Time to a Number
Not sure why you're getting that error. My best guess is it has something to
do with the Analysis ToolPak add-in which is required for the CONVERT function. You really don't need to use the CONVERT function. This will do the same thing: =P14*1440 Format as General or Number -- Biff Microsoft Excel MVP "Connie" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Time to a Number
Hi T.
Thank you for your response. As you say, didn't need to use CONVERT. Instead, I used (D14-INT(D14))*24*3600/60. This works perfectly. P14*1440 changes the cell format to Time, even though I make it General or Number. Connie "T. Valko" wrote: Not sure why you're getting that error. My best guess is it has something to do with the Analysis ToolPak add-in which is required for the CONVERT function. You really don't need to use the CONVERT function. This will do the same thing: =P14*1440 Format as General or Number -- Biff Microsoft Excel MVP "Connie" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Time to a Number
P14*1440 changes the cell format to Time,
even though I make it General or Number. That's just Excel being "helpful". After Excel is done being "helpful" just change the format to General or Number. -- Biff Microsoft Excel MVP "Connie" wrote in message ... Hi T. Thank you for your response. As you say, didn't need to use CONVERT. Instead, I used (D14-INT(D14))*24*3600/60. This works perfectly. P14*1440 changes the cell format to Time, even though I make it General or Number. Connie "T. Valko" wrote: Not sure why you're getting that error. My best guess is it has something to do with the Analysis ToolPak add-in which is required for the CONVERT function. You really don't need to use the CONVERT function. This will do the same thing: =P14*1440 Format as General or Number -- Biff Microsoft Excel MVP "Connie" wrote in message ... 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 |
Reply |
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) |