Time Formulas

F

famdamly

I formatted column A Time

A3- 6:00am
A4- I need a formula that = A3+30 minutes.
So I can fill the rest of the rows quickly.
I tried several guesses but I give up. It must be easy if you know
it.:)
 
F

famdamly

Sorry I double posted. This question was already answered. I couldn'
find the post
 
D

David Biddulph

famdamly said:
I formatted column A Time

A3- 6:00am
A4- I need a formula that = A3+30 minutes.
So I can fill the rest of the rows quickly.
I tried several guesses but I give up. It must be easy if you know
it.:)
Click to expand...

A4 =A3+1/48 would do.
Times are in fractions of a day.
 
Top