Home |
Search |
Today's Posts |
#1
|
|||
|
|||
subtact between times
I want to find the difference or elasped time between to times. my
spreadsheet is setup like this: columnA columnB columnc START END difference TIME TIME 22.41.34 23.18.11 =(b1 - a1) the cells are formattted as time but the value returnd in c1 is #VALUE! Any suggestions are appreciated. |
#2
|
|||
|
|||
MrEyes,
Excel reads time as decimal values, so the multiple decimals are throwing it off. Once you tell Excel how to read your data you'll be fine. I'm assuming part1.part2.part3 translates to hour.minute.second If so, use this formula: =TIME(LEFT(B1,2),MID(B1,4,2),RIGHT(B1,2))-TIME(LEFT(A1,2),MID(A1,4,2),RIGHT(A1,2)) Basically it takes the value in each cell, cuts it up into pieces, and tells Excel that the first two characters are the HOUR, the two characters in the middle are the MINUTE, and the right two characters are the SECOND. Knightly Quote:
__________________
--- SirKnightly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How are relay leg times or driving times entered and totaled? | Excel Worksheet Functions | |||
Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Formula for averaging times | Excel Discussion (Misc queries) | |||
SUMPRODUCT ON TIMES | Excel Worksheet Functions |