| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Add colon to times
Is there a way to add a colon (:) to times?
Example: At the moment I have A1 (hours) 2 B1 (minutes) 4 C1 (seconds) 8.321 I want these to end up in a single time cell as 2:4:8.321 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Add colon to times
One way:
=(A1+(B1+C1/60)/60)/24 In article , meridklt wrote: Is there a way to add a colon (:) to times? Example: At the moment I have A1 (hours) 2 B1 (minutes) 4 C1 (seconds) 8.321 I want these to end up in a single time cell as 2:4:8.321 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Add colon to times
Many thanks JE McGimpsey
|
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Add colon to times
Another way:
=TIMEVALUE(A1&":"&A2&":"&A3) and format as h:mm:ss.000 Bob Umlas Excel MVP "meridklt" wrote: Is there a way to add a colon (:) to times? Example: At the moment I have A1 (hours) 2 B1 (minutes) 4 C1 (seconds) 8.321 I want these to end up in a single time cell as 2:4:8.321 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Add colon to times
I'm KOREAN MIN ZUN SEO Excel mvp.
Hi. Long Time No See. Thanks A Lot. "Bob Umlas, Excel MVP" wrote: Another way: =TIMEVALUE(A1&":"&A2&":"&A3) and format as h:mm:ss.000 Bob Umlas Excel MVP "meridklt" wrote: Is there a way to add a colon (:) to times? Example: At the moment I have A1 (hours) 2 B1 (minutes) 4 C1 (seconds) 8.321 I want these to end up in a single time cell as 2:4:8.321 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas need semi-colon, how to change to comma | Excel Discussion (Misc queries) | |||
| Is there a way to enter times without typing a colon? | Excel Discussion (Misc queries) | |||
| Insert colon in text in cell | Excel Discussion (Misc queries) | |||
| Format cell to show colon | Excel Worksheet Functions | |||
| Replace nth place with colon | Excel Worksheet Functions | |||
Linear Mode
