In Excel 2007, I want to distinguish the date for the following dates:
ABC Date 1 Date 2 A and B2 Difference 2009.11.28 01: 25: 46: 0287 2009.11.28 01: 25: 46: 0287? 3 2009.11.28 01: 25: 46: 0443 2009.11.28 01: 25: 46: 0443?
Please help me with a formula in Excel 2007 to get the distinction of the above dates.
Excel stores date 1 = 01/01/1900, since = dates in the form of numbers, So you can just take the difference
C2 = A2-B2
You will give a difference in days.
If you want it in seconds, for example, then:
C2 = (A2-B2) * 24 * 60 * 60
If you need to parse the string with a fraction of seconds:
= DATE (center (A1, 4), middle (A2, 6,2), Central (A2, 9, 2)) + TIME (Middle (A2, 12, 2), Mid (A2, 15,2), Mid (A2, 18,2)) + Mid (A2, 21, 4) / (24 * 60 * 60 * 10000)
convert A2 to Excel date time. I recommend that you put it in cell D2 and copy it to e2. C2 can then be based on them.
No comments:
Post a Comment