Time Formulas
 

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.:)


--
famdamly
------------------------------------------------------------------------
famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=517906

Time Formulas
 

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


--
famdamly
------------------------------------------------------------------------
famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=517906

Time Formulas
 

"famdamly" wrote in
message ...

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.:)

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