Himanshu's time format

H

Himanshu

I have a huge amount of data in which the time format
is :00:12 and i need to add zero's in the begining i.e. it
should appear like 0:00:12. I have tried all the time
formats but they dont function. is there someway i can do
this? or doi need to add these zer's manually
 
N

Norman Harker

Hi Himanshu!

Formatting won't help you as it is the number stored that is the problem.

Two ways:
Create a helper column and use:
=A1/60

Or

Put 60 in a cell
Select that cell > Copy
Select the cells you want to change
Edit > Paste Special > Divide > OK

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top