Hi

kindly help how to format the time by using formula in excel.

for example,

Correct time to be entered in work sheet is 0:05:23, however it was entered by mistake as 05:23:00

ie. hour is supposed to be zero and seconds to be 23.

Many thanks.