View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default Excel is too complicated for me

"Leah1668" wrote:
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.


Decimal what?!

If decimal days, try:

=A1+TIME(B1,C1,0)
or
=A1 + B1/24 + C1/1440

formatted as Number, where A1 is days, B1 is hour, and C1 is minutes.

If decimal hours, try:

=(A1+TIME(B1,C1,0))*24
or
=A1*24 + B1 + C1/60

If decimal minutes, try:

=(A1+TIME(B1,C1,0))*1440
or
=A1*1440 + B1*60 + C1

The multipliers are derived from the fact that Excel time is represented as
a fraction of a day. There are 24 hours or 1440 (24*60) minutes in a day.