# Count by hours...

#### jimmy2468

##### New Member
I'm sure this is an easy one, but having some trouble....
I would like to add hours to a time entered in a field.

That is... I have 2:00PM entered in A2, and would like to add 61 hours (in B2) to this time to generate only the time of day that this addition reflects.

So 2:00PM + 61 = 3:00AM

Can anyone help me out?

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### barry houdini

##### MrExcel MVP
Try

=MOD(A2+61/24,1)

format as h:mm AM/PM

#### yee388

##### Well-known Member
Welcome to the board!

=A2+(B2/24)

Format destination cell as needed.

Remember, all dates (times) are actually numbers. Each 1 is a day, so .5 is 12 hours and so on... To convert 61 to hours, divide by 24.

Thanks!!

Replies
19
Views
508
Replies
2
Views
97
Replies
21
Views
369
Replies
23
Views
821
Replies
17
Views
456

1,171,168
Messages
5,874,152
Members
433,029
Latest member
theodoros1

### 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