| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Format Help Please
Hi All, I have a spread sheet with sun rise/sunset times for one year. Times does not have ":" in between. 6:02 is written as 602. Like to see if there is a quick way to add : in between the numbers. In some places it would be after one number from left and in some cases it would be after 2 numbers from left. I hope someone can help me. Thank Syed -- saziz ------------------------------------------------------------------------ saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350 View this thread: http://www.excelforum.com/showthread...hreadid=520363 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Text to Time format of XX:XX | Excel Discussion (Misc queries) | |||
| Adding Time Format | Excel Discussion (Misc queries) | |||
| Adding Time Format | Excel Discussion (Misc queries) | |||
| Converting from time format to decimal and figuring the difference | Excel Discussion (Misc queries) | |||
| Adding time | Excel Discussion (Misc queries) | |||
Threaded Mode
