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 |
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) |