To add a Date/time value with time(hours)

[arunprasad]

Hi Everybody,

I want to add number of hours to a column value which is in mm/dd/yy hh:mm:ss format.

For eg:
if we add 30 hours to 11/13/05 1:00 PM the result should be 11/14/05 7:00 AM.

Is there any function in excel which can add the hours part and give the result accordingly.

Thanks in Advance,
Arun

 

[RalphA]

Say A1 contains 30 (the hours)
Say B1 contains 11/13/2005 1:00
Say C1 contains the formula, =A1+B1/24
The result in C1 will be, 11/04/2005 7:00

Note, your example gave B1 as 11/13/05 1:00 PM. It should have been AM.

Also, the result is not reported as AM or PM, but in military time.

 

[arunprasad]

hi Ralph,


I dont understand ur solution .can u pls explain me .

Thanks,
arun

 

[RalphA]

Sorry! Please change the formula to:

Say C1 contains the formula, =A1/24+B1

Since Excel dates works with days, to add, say, 30 hours to a date & time, we must convert the hours to days by dividing by 24.

 

[arunprasad]

Thanks Ralph...it worked