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