Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    67

    Unanswered: Difference between timestamps

    Not a question, just a tip.

    A1 (beginning timestamp):
    2013-09-18-11.51.56
    B1 (ending timestamp):
    2013-09-18-11.55.49
    C1 (difference):
    =(((((((VALUE(TEXT(LEFT(B1;10);"YYYY-MM-DD"))*24)+VALUE(MIDB(B1;12;2)))*60)+VALUE(MIDB(B1; 15;2)))*60)+VALUE(MIDB(B1;18;2)))-((((((VALUE(TEXT(LEFT(A1;10);"YYYY-MM-DD"))*24)+VALUE(MIDB(A1;12;2)))*60)+VALUE(MIDB(A1; 15;2)))*60)+VALUE(MIDB(A1;18;2))))/24/60/60

    If you format C1 with
    [h]:mm:ss;@
    you can have differences of more than 24 hours.

    List separator=";"
    Last edited by CCMF; 09-19-13 at 12:09.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    would it not make more sense to use the date functions inherent within excel.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2004
    Posts
    67
    It doesn't work using Year(2013-09-18-11.51.56) or the other date/time formulas, so I have to extract the date/time part I need to.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •