4
I have data in this format:
Action (A) | Time logged (B)
---------------------------------|-----------------------
1 |Policy converted successfully | 19-FEB-10 18:34:01
2 |Policy converted successfully | 19-FEB-10 18:34:10
3 |Policy converted successfully | 19-FEB-10 18:34:21
I need to find the time difference between row 2 and row 1, in seconds ( or minutes/hours). How can I do the same using OpenOffice.org Calc ?
I tried =B2-B1
, the resulting cell had an Err: 529
as the result.
I've tried putting format mask of DD-MMM-YY HH:MM:SS
on the source as well as the destination cells, but to no effect. Any hints as to how to accomplish this ?
There are about 2,800 rows of records, going through each is just not possible.
Daylight saving time, anyone? – Arjan – 2010-02-24T10:41:14.027
(And if this is an import of some text file, then explicitly defining date-time columns as date-times while importing might help.) – Arjan – 2010-02-24T10:57:07.733
@Arjan - DST is not applicable here :) – Sathyajith Bhat – 2010-02-24T21:02:52.080