View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

Since 1 = 1 full day in Excel, 3.25 hours would be
3.25/24. Example formula:

=A1+3.25/24

HTH
Jason
Atlanta, GA

-----Original 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?

.