RE: Time Between Failure

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

According to my understanding of your description, Column H and I contain
text that is not related to time.

http://www.contextures.com/xlfaqDat.html

has information on date/time math that you might find useful.

If not, try provideing an example of some of the data and what result you
are looking for.


"Maintenance" wrote:

I can't seem to figure out how to make this work, I need to find out what the
time between failure on a particular machine is. My spreadsheet is laid out
as follows:
Column B - Date
Column C - Time
Column H - Location (Cell 1, Cell 1A, Cell 1B)
Column I - Machine (Winder, Extractor....)

If i could see how much time (days, hours, mins) between entries on first on
Column H, then broken down further with Column I

Thank you
.

Relevant Pages

  • Re: Good Logic is Very Important
    ... essence of understanding how it works is by applying good logic. ... So it is that the list of logical fallacies can sometimes include ... entries based on illogical conclusions. ...
    (sci.crypt)
  • Re: Report Sum If <=
    ... If I'm understanding what you are trying to do, do it in the query. ... create the new expression (your IIF statement). ... I would like to display only those entries who meet the criteria or flag ...
    (microsoft.public.access.reports)
  • Re: Request for Comments: libarchive, bsdtar
    ... but my understanding is that it has to pull in a lot of ... Since tar files are a well ... > with ownership/permissions different than is in the unpriv'd build ... ustar/gzip archive to stdout with all entries owned by 'root'. ...
    (freebsd-arch)
  • IPMON Format ???
    ... A little help please with understanding the format of ipmon.log. ... I have entries like this (mind line-wrap): ...
    (freebsd-questions)