Thread: Time formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
famdamly
 
Posts: n/a
Default Time formulas


I went to make a schedule for printing out for manual fill in.
I changed the format of column A to time.
I entered the first time in A3

A3 6:00am
A4 =A3+:30 didnt work
A4= A3+30 didn't work
A4=A3+.5 didn't work
Those were just guesses.
What's the right way?


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