Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Converting Time Data
My time data comes in like so:
93555 93600 Difference of 5 seconds 103058 103101 Difference of 3 seconds Is there a way to convert these trimes so that when they are subtracted, I can get the correct difference ? Thank you in advance. |
#2
|
|||
|
|||
One way to convert those values into times is to use a helper cell:
=TIMEVALUE(TEXT(A1,"00\:00\:00")) (format as time) But you could do all the work in the subtraction formula, too: =TIMEVALUE(TEXT(A2,"00\:00\:00"))-TIMEVALUE(TEXT(A1,"00\:00\:00")) (format as time, too) A2 held the later time. carl wrote: My time data comes in like so: 93555 93600 Difference of 5 seconds 103058 103101 Difference of 3 seconds Is there a way to convert these trimes so that when they are subtracted, I can get the correct difference ? Thank you in advance. -- Dave Peterson |
#3
|
|||
|
|||
Hi Carl
If your data always has the latest time in the second cell, then with early time in A1 and late time in A2 =RIGHT(A2,2)-RIGHT(A1,2)+60 works for me -- Regards Roger Govier "carl" wrote in message ... My time data comes in like so: 93555 93600 Difference of 5 seconds 103058 103101 Difference of 3 seconds Is there a way to convert these trimes so that when they are subtracted, I can get the correct difference ? Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
How do I format cells and enter data to be valued for TIME and th. | Excel Worksheet Functions | |||
move data to a single cell and at the same same time filter the da | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Can't stop time duration [hh]:mm:ss converting to time of day | Excel Discussion (Misc queries) |