View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Converting Hours:Minutes to Decimal

=A1*24 format as general
--
Gary''s Student - gsnu200742


"Michael" wrote:

Hi Folks - I've got a mental block .... How can I convert the elapsed time
of 07:15 (seven hours and 15 minutes) to the decimal format 7.25 (seven and
a quarter hours)? Thanks.

--
Michael