View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
daddylonglegs
 
Posts: n/a
Default In Excel, how can I convert h:mn to mn?


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