time format

[Himanshu]

hi,

I have this huge amount of data in which the ime format is
like :00:12 and I need to add zero's in trhe begining i.e.
0:00:12. I have tried all the time formats and nothing
works can someone recommend anyway of doing it?

 

[Frank Kabel]

Hi
see your other post.

P.S.: please don't multipost

 

[Norman Harker]

Hi Himanshu!

No need to post to more than one group. Here's the reply given in misc:

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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.