time format

H

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?
 
N

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top