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
|