Adding and subtracting hh:mm

[kues]

Good day...

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

Thanks folks.

 

[lenze]

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

lenze

 

[kues]

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

 

[Scott Huish]

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

Excel Workbook
	A	B	C	D
1	12:52	12	*	24:52
Sheet1

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

Excel Workbook
	A	B	C	D
1	12:52	-7		5:52
Sheet1

 

[kues]

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

 

[jeffreybrown]

What is in F7 and what do you expect as the answer?

Try this...

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

 

[kues]

Sorry... F7 is just a time.

 

[kues]

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