View Single Post
  #3   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

Hi

Something like
=A2+50.5/24
with date in A2


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)


"Rich" wrote in message
...
Hi,

I want to add a number of hours to a date and a time and have Excel give

me
the resulting date and time. The hours that I will want to add to the

date
could be
anything, including part days, eg 3.25 hours, 92.4 hours, and so on.

For instance

1st Dec 2004 13:00

Add 50.5 hours

Result: 3rd Dec 2004 15:30

What is the formula that I need to achieve this?