• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 326
  • Last Modified:

Determining time difference between two lines.

I have a very large file which shows when a site looses power and when that site powers-up again.
Each site has two lines - the first line shows when the site looses power and the second line shows when the site powers up again. Column D contains the timestamp when these events occur.
Can you tell me please what the code is which will show, in seconds, the outage time in column E. (Note: bear in mind that the outage may extend over a number of days therefore it's important to note the date part of the timestamp too)
Many thanks.

A              B              C                                     D
3713      Site A      15/09/2011 02:19:27      Event 1 at 2011-09-15 02:19:27.0 : Power down
3713      Site A      15/09/2011 02:19:42      Event 2 at 2011-09-15 02:19:42.0 : Power up
5397      Site B      15/09/2011 02:35:32      Event 1 at 2011-09-15 02:35:32.0 : Power down
5397      Site B      15/09/2011 02:36:12      Event 2 at 2011-09-15 02:36:12.0 : Power up

1 Solution
barry houdiniCommented:
Column C looks like it has the time/date in a viable format - you can simple subtract and convert to get seconds, e.g. in E2


format E2 as number with no decimal places

To copy down leave e1 blank, select e1 and E2 and drag/fill down column

regards, barry
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now