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
|