Thread: Need to convert hours and minutes to hours and tenths.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
mphell0
 
Posts: n/a
Default Need to convert hours and minutes to hours and tenths.

An even easier way would be to multiply the time by 24 and format as
general

=A1*24


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=510641

Reply With QuoteReply With Quote