Time and date from string to calculation

[mtheriault2000]

Hello

I got 2 string that represent time as (yyyymmdd hh:mm:ss)

t1 = "20110922 18:57:00"
t2 = "20110922 19:00:02"

Now, I need to calculate

(T2- T1) + T2

What is the step that I need to accomplish to get the result equal to
"20110922 19:03:00"

How do I transform a string date to a string number

Martin

 

[mtheriault2000]

Re: Resolved: Time and date from string to calculation

You might want to study my 3-Format-Statements solution... it is much more compact and, in my view, easier to read/maintain (once you understand the @ metacharacter usage that is).

Good Idea
I did post my solution before reading yours. Il like it because your format is well defined

Many thanks
Martin

 

[bebo021999]

If your date are in A1 and A2:

Try this formula:

=(DATE(LEFT(A2,4),MID(A2,5,2),MID(A2,7,2))+TIMEVALUE(RIGHT(A2,8)))*2-DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))-TIMEVALUE(RIGHT(A1,8))

Format date as: "yyyymmdd hh:mm:ss"