Aug 09 2019 07:35 AM
Aug 09 2019 10:08 AM
SolutionIf you are not going to do any calculations with time, you may apply custom format 00\:00\:00
But the cell value will be initial number (123456), not the time value which is equivalent to 0.524259259259259 for the time 12:34:56.
Otherwise with VBA or by adding helper column to transform such number to time.
Feb 19 2020 02:47 PM
Aug 09 2019 10:08 AM
SolutionIf you are not going to do any calculations with time, you may apply custom format 00\:00\:00
But the cell value will be initial number (123456), not the time value which is equivalent to 0.524259259259259 for the time 12:34:56.
Otherwise with VBA or by adding helper column to transform such number to time.