Thread: Add half hour
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Add half hour

assuming you have 06:00 AM on g7.
on g8 use =g7+(0.5/24) hit enter and drag it down

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Connie Martin" escreveu:

If I formulate a column to time, and if the time in the first cell is 6:00 AM
and I drag it down, it advances by one hour. How do I get it to advance by a
half hour?
Connie