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

##### New Member
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.

Arun

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
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.

hi Ralph,

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

Thanks,
arun

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.

Thanks Ralph...it worked

Replies
10
Views
256
Replies
6
Views
118
Replies
9
Views
266
Replies
8
Views
348
Replies
1
Views
534

1,203,026
Messages
6,053,110
Members
444,639
Latest member
xRockox

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back