ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I complete increments of time in column A by say 9 min? (https://www.excelbanter.com/excel-discussion-misc-queries/212036-how-do-i-complete-increments-time-column-say-9-min.html)

Sandiness

How do I complete increments of time in column A by say 9 min?
 

--
Sandiness

Shane Devenshire[_2_]

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



All times are GMT +1. The time now is 05:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com