View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
connie connie is offline
external usenet poster
 
Posts: 46
Default 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