Can't format cells into time

%3CLINGO-SUB%20id%3D%22lingo-sub-1795820%22%20slang%3D%22en-US%22%3ECan't%20format%20cells%20into%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1795820%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20column%20which%20is%20in%20the%20format%3A%20h%3Amm%3Ass%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20formatting%20shows%20as%20time%2C%20but%20it%20is%20clearly%20text%20as%20it%20is%20on%20the%20left%20hand%20side%20of%20the%20cells.%20When%20I%20edit%20each%20cell%20it%20shifts%20to%20the%20right%2C%20but%20I%20can't%20figure%20out%20how%20to%20do%20this%20en%20masse.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20would%20I%20go%20about%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EMorgan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1795820%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1796092%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20format%20cells%20into%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1796092%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F789072%22%20target%3D%22_blank%22%3E%40morgancampbell%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMorgan%2C%20as%20variant%3C%2FP%3E%0A%3CP%3E-%20enter%20zero%20into%20any%20empty%20cell%3C%2FP%3E%0A%3CP%3E-%20select%20cells%20with%20time%20as%20text%3C%2FP%3E%0A%3CP%3E-%20Paste-%26gt%3BPaste%20Special-%26gt%3BAdd%3C%2FP%3E%0A%3CP%3EResult%20will%20be%20converted%20to%20General%20format%2C%20apply%20Time%20format%20to%20the%20selection%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I have a column which is in the format: h:mm:ss

 

The formatting shows as time, but it is clearly text as it is on the left hand side of the cells. When I edit each cell it shifts to the right, but I can't figure out how to do this en masse.

 

How would I go about this?

 

Thanks,

Morgan

1 Reply
Highlighted

@morgancampbell 

Morgan, as variant

- enter zero into any empty cell

- copy this cell

- select cells with time as text

- Paste->Paste Special->Add

Result will be converted to General format, apply Time format to the selection