excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1305649%22%20slang%3D%22en-US%22%3Eexcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1305649%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20make%20alignment%20of%20clock%20according%20to%20minute%20on%20the%20cloumn.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esuch%20as%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E12%3A30%3C%2FP%3E%3CP%3E12%3A31%3C%2FP%3E%3CP%3E12%3A32%3C%2FP%3E%3CP%3E....%20like%20this%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20do%3F%20Could%20you%20help%20me%20please%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1305649%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1305687%22%20slang%3D%22en-US%22%3ERe%3A%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1305687%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F620891%22%20target%3D%22_blank%22%3E%40Onurgurses%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EType%20in%20first%20two%20cells%3C%2FP%3E%0A%3CP%3E12%3A30%3C%2FP%3E%0A%3CP%3E12%3A31%3C%2FP%3E%0A%3CP%3Eselect%20both%20and%20drag%20down%2C%20AutoFill%20will%20do%20the%20job.%20The%20same%20if%20drag%20down%20by%20right%20mouse%20and%20Fill%20Series.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Dear All,

 

I want to make alignment of clock according to minute on the cloumn.

 

such as,

 

12:30

12:31

12:32

.... like this

 

How can I do? Could you help me please

1 Reply
Highlighted

@Onurgurses 

Type in first two cells

12:30

12:31

select both and drag down, AutoFill will do the job. The same if drag down by right mouse and Fill Series.