#### kues

##### New Member
Good day...

How can I add or subtract 12h to a field that contains a time in hh:mm?

Thanks folks.

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

#### lenze

##### Legend
Since 12 hrs is 1/2 day, add or subtract 0.5

lenze

#### kues

##### New Member
It's not allways 12h. Sometimes it's more, sometimes it's less. Thanks

#### Scott Huish

##### MrExcel MVP
With your original time in A1, and the amount of hours to add in B1.
Format B1 as [h]:mm

Excel Workbook
ABCD
112:5212*24:52
Sheet1

If you want to subtract hours put negative hours in B1, not surpassing the amount of original hours.

Excel Workbook
ABCD
112:52-75:52
Sheet1

Last edited:

#### kues

##### New Member
Is my function correct if I add 12h to the field F7: =F7+("12:00">F7)-"12:00"?

#### jeffreybrown

##### Well-known Member
What is in F7 and what do you expect as the answer?

Try this...

=F7+(TIMEVALUE("12:00") > F7)-TIMEVALUE("12:00")

Last edited:

#### kues

##### New Member
Sorry... F7 is just a time.

#### kues

##### New Member
Thanks JRB it works... Great... You made my day.
Have a good one.

Replies
10
Views
154
Replies
7
Views
220
Replies
2
Views
110
Replies
7
Views
497
Replies
5
Views
110

1,191,174
Messages
5,985,102
Members
439,940
Latest member

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