Thread: How do I complete increments of time in column A by say 9 min?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
  
Posts: 3,346
Default How do I complete increments of time in column A by say 9 min?
Hi,

Enter the first time in A1, say
8:00 AM
Then enter the second increment in A2
8:09 AM
Highlight A1:A2 and drag the fill handle down as far as you want.

You can use this technique for any fixed increment.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Sandiness" wrote:


--
Sandiness
Reply With QuoteReply With Quote