Thread: Add half hour
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Steve[_13_] Steve[_13_] is offline
external usenet poster
 
Posts: 8
Default Add half hour

On May 21, 11:40*am, Connie Martin
wrote:
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


Place 6:30 in the cell below it and than select both cells and drag
down. This will set the time to 30 minute intervolts