Adding numbers to a Time Formated cell
 

if cells were formated to time (i.e. 00:00:00) but if some only looked
like:

05:00
06:00... How could you add the first series of "00" to them using a
formula.

Basically my data set looks like:

01:00:00
05:00
06:00


and for the final two i wanted to add the other series of zero's, how
would i do that using a formula?


--
Browner
------------------------------------------------------------------------
Browner's Profile: http://www.excelforum.com/member.php...o&userid=33657
View this thread: http://www.excelforum.com/showthread...hreadid=553517

Adding numbers to a Time Formated cell
 

You need to checK what your cells contain

if 05:00 is 5 hours no minutes it can be changed to 05:00:00 by
formating as hh:mm:ss

If it is mm:ss and you wish it to be hh:mm:ss eg your minutes should be
hours and seconds should be minutes multiply it by 60 and format as
hh:mm:ss

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=553517

Adding numbers to a Time Formated cell
 

what about if some of the values apear as such:

:05:00
:06:00

and yes this does represent 5 mins/6mins respectively.

how would i get the "hh" to show up as zero's?


--
Browner
------------------------------------------------------------------------
Browner's Profile: http://www.excelforum.com/member.php...o&userid=33657
View this thread: http://www.excelforum.com/showthread...hreadid=553517