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?
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 5 minutes, no seconds try formating hh:mm:ss and the leading 00 should appear
If it is hours and minutes and you wish it to be minutes and seconds divide by 60.
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
Last edited by Dav; 06-20-2006 at 03:45 AM.
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks