View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Excel is too complicated for me

Hi Leah,

Am Sat, 15 Feb 2014 16:41:35 +0000 schrieb Leah1668:

I need to convert 3 cells, one being DAYS, the second Hours, and the
third MINS into a 4th cell which needs to be a decimal. Can anyone tell
me how to do this?


days in A1, hours in B1, minutes in C1 then
=A1+B1/24+C1/1440


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2