Formula for time in a cell + 30 minutes?

[Dreammy]

I am trying to formulate for this idea.

I have the "Now" time in one cell, I need a formula that will be in other cells at time markers

starting time cell will equal now time.
next cell will display now time plus 30 minutes
next cell will display now time plus and hour
next cell will display now time plus 2 hours

can anyone help me out?

[dominicb]

Good morning Dreammy

...and welcome to the forum!!

Say you ahve the formula =NOW() in cell A1 formatted as time.
The formula =A1+1 will add 1 day onto the time now.
With that in mind take a look at the following formulae :

starting time cell will equal now time. =NOW()
next cell will display now time plus 30 minutes =A1+1/48
next cell will display now time plus and hour =A1+1/24
next cell will display now time plus 2 hours =A1+1/12

HTH

DominicB

[Dreammy]

Good morning Dreammy

...and welcome to the forum!!

Say you ahve the formula =NOW() in cell A1 formatted as time.
The formula =A1+1 will add 1 day onto the time now.
With that in mind take a look at the following formulae :

starting time cell will equal now time. =NOW()
next cell will display now time plus 30 minutes =A1+1/48
next cell will display now time plus and hour =A1+1/24
next cell will display now time plus 2 hours =A1+1/12

HTH

DominicB

Thank YOU!!!