Try
=(A1-B1)*24*60
Format as numeric, not time.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"caresaboutquality"
wrote in message
...
I have successfully subtracted two times and get the answer in
hr:mn format.
I wish to convert this back to minutes. How can this be done
easily? I
can't get the convert function to recognize the custom format
of hr:mn that I
used.
Thank you for your help!