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!

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!

caresaboutquality Wrote:
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!

If it's just for display purposes you could use custom format

[m]


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=537866