Adding numbers to a Time Formated cell

B

Browner

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

05:00
06:00... How could you add the first series of "00" to them using
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, ho
would i do that using a formula
 
D

Dav

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
 
B

Browner

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
 
Top