View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan Alan is offline
external usenet poster
 
Posts: 492
Default Trying to convert hh.mm.ss in General format to minutes

Have you tried formatting N21 as time?
Regards,
Alan.
"jeannie v" wrote in message
...
Hi Experts:

I have tried all of the posts on this subject and cannot make it
work....Is
there something I'm missing? I am copying the time from another worksheet
and it shows as being formatted as "General"....Is there some formula I
can
use beside the =N21*1440? This gives me a "#VALUE".

Any help would be appreciated...Thank you,
--
jeannie v