Adding time to a MOD function formula

[TAPS_MikeDion]

Hi all,
How can you add time (2 hours in my case) to time calculated by the MOD function?

I'm currently using the formula =MOD(J2-H2,1) to get my time, in hours, from start time (column H) and end time (column J) columns. The formula works fine, but I need to add 2 hours to the calculated hours without changing the start and end times. Is there something I can add to my formula to do this?

Thank you!

 

[DanteAmor]

Try just:

=(J2-H2)+("2:00")

or

=(MOD(J2-H2,1))+("2:00")

 

[Fluff]

Another option

=MOD(J2-H2,1)+TIME(2,0,0)

 

[TAPS_MikeDion]

Thank you both, both solutions worked!!!

The forum will only allow me to mark one post as the solution. DanteAmor's post was first so I selected that one, but you're both awesome!

 

[Fluff]

Glad we could help & thanks for the feedback.