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


=HOUR(A1)+MINUTE(A1)/60

Format as general


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