| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting Times
My Time Data is in ColA and B. I am trying to find a formula for ColC. I also
need to be able to add and subtract ColC. Time MilliSeconds Time2 93015 1 9:30:15.001 AM 93015 10 9:30:15.010 AM Thanks You In Advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Converting Times
I'm not exactly sure what you are after, but maybe this will do it for you:
=LEFT(A2,1)&":"&MID(A2,2,2)&":"&RIGHT(A2,2) Regards, Ryan-- -- RyGuy "carl" wrote: My Time Data is in ColA and B. I am trying to find a formula for ColC. I also need to be able to add and subtract ColC. Time MilliSeconds Time2 93015 1 9:30:15.001 AM 93015 10 9:30:15.010 AM Thanks You In Advance. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Converting Times
That doesn't deal with the milliseconds in column B, and have you looked at
what it does with 103015 as a column A time input? [And being a text string result, some further calculations wouldn't work.] -- David Biddulph "ryguy7272" wrote in message ... I'm not exactly sure what you are after, but maybe this will do it for you: =LEFT(A2,1)&":"&MID(A2,2,2)&":"&RIGHT(A2,2) "carl" wrote: My Time Data is in ColA and B. I am trying to find a formula for ColC. I also need to be able to add and subtract ColC. Time MilliSeconds Time2 93015 1 9:30:15.001 AM 93015 10 9:30:15.010 AM Thanks You In Advance. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Converting Times
=TIME(INT(A2/10000),MOD(INT(A2/100),100),MOD(A2,100))+B2/(24*3600*1000)
-- David Biddulph "carl" wrote in message ... My Time Data is in ColA and B. I am trying to find a formula for ColC. I also need to be able to add and subtract ColC. Time MilliSeconds Time2 93015 1 9:30:15.001 AM 93015 10 9:30:15.010 AM Thanks You In Advance. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Converting Times
=TEXT(A2,"00\:00\:00")+B2/86400000
Format cell as: h:mm:ss.000 "carl" wrote: My Time Data is in ColA and B. I am trying to find a formula for ColC. I also need to be able to add and subtract ColC. Time MilliSeconds Time2 93015 1 9:30:15.001 AM 93015 10 9:30:15.010 AM Thanks You In Advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Averaging times (similar to lap times) | Excel Discussion (Misc queries) | |||
| Calculation of hourly rate times hours times 1.5 | Excel Worksheet Functions | |||
| How are relay leg times or driving times entered and totaled? | Excel Worksheet Functions | |||
| =Text(b2-A2,"h") hours between 2 times, what do I do for 10 times | New Users to Excel | |||
| Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
Hybrid Mode
