Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding zero's to Time formated cell
I have a series of values(expressed in time format 00:00:00) but for some reason some only appear as 00:00, which is fine but i want to just add the preceding zeros to the existing values. For example if i had the following values: 01:00:00 01:00 02:00 but i wanted it to look like: 01:00:00 00:01:00 00:02:00 How could i do that using a formula? Thanks, -- Browner ------------------------------------------------------------------------ Browner's Profile: http://www.excelforum.com/member.php...o&userid=33657 View this thread: http://www.excelforum.com/showthread...hreadid=553519 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding zero's to Time formated cell
Under Tools Format Cells there is a "Time" format like the one you require.
If you want to format the cells as text with a formula you can use: "=TEXT(A1,"hh:mm:ss")" Hope this helps Ian -- Work performed in the spirit of service is worship...Baha''i Writings "Browner" wrote: I have a series of values(expressed in time format 00:00:00) but for some reason some only appear as 00:00, which is fine but i want to just add the preceding zeros to the existing values. For example if i had the following values: 01:00:00 01:00 02:00 but i wanted it to look like: 01:00:00 00:01:00 00:02:00 How could i do that using a formula? Thanks, -- Browner ------------------------------------------------------------------------ Browner's Profile: http://www.excelforum.com/member.php...o&userid=33657 View this thread: http://www.excelforum.com/showthread...hreadid=553519 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding zero's to Time formated cell
what about if some of them appear as such: :05:00 :03:00 How can i get the "HH" to show up as Zero's? b/c some of the data set already have the ":" before the first value and i can't get it to show up as "hh:mm:ss". -- Browner ------------------------------------------------------------------------ Browner's Profile: http://www.excelforum.com/member.php...o&userid=33657 View this thread: http://www.excelforum.com/showthread...hreadid=553519 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding zero's to Time formated cell
"Browner" wrote in
message ... what about if some of them appear as such: :05:00 :03:00 How can i get the "HH" to show up as Zero's? b/c some of the data set already have the ":" before the first value and i can't get it to show up as "hh:mm:ss". Are you sure that the cells aren't formatted as text, rather than as times? You may need to convert from text to times before your format will work. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding zero's to a text cell | Excel Worksheet Functions | |||
Adding time | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions | |||
How do I get one cell to record the time another cell was changed. | Excel Discussion (Misc queries) |