Adding hours to time to get new time

**djarcadian** · 03-30-2009, 05:03 PM

I have a started time of say 8am from cell B3. I want to know what time it will be when I add a full number (hours) from another cell. For example A3+B4 where A3 is 8:00 A.M. and B4 is 4.04. I'm looking to get the a result of 12:04 P.M.

**shg** · 03-30-2009, 05:55 PM

Dates and times in Excel are the same thing; whole numbers are days since 0 Jan 1900, and decimals are time. So you just need to convert the hours to days and then add:

=A3 + B4/24

**djarcadian** · 03-30-2009, 06:30 PM

Hmm, I'm kind of confused so bare with me.

I have the following code =IF(Sheet3!E104>0,SUM(Landscaping!C3)," ")

The Landscaping!C3 gives me a time like 8:56 AM. I want to add 30 minutes to it so it displays 9:26 AM.

How would i accomplish this?

**djarcadian** · 03-30-2009, 06:36 PM

Figured it out!

=IF(Sheet3!E104>0,SUM(Landscaping!C3)+TIME(0,30,0)," ")

**shg** · 03-30-2009, 06:48 PM

Good job. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes