Hi,

I have 6 time variables from which I would like to reliably calculate the total time elapsed.

I am not quite sure how to go about it - My current formula doesn't handle exceptions very well.

Note that there are no dates associated with the time variables, but if a time looks smaller than the time in the column to its left, assume that the date incremented by 1. (You can see how I did that in the formulae provided in the worksheet)

To make your life easier helping me with this, I have already included the desired output which I have corrected manually.

Note that there are a number of blank cells around, which are intentionally blank (missing data)

Ideally no additional columns should be relied on that don't already exist due to space limitations on the original file.

Thanks for any help you can offer.

Use Workbook.xlsx for trying to find a working formula.

Alternatively:

--

jason.b75 provided this formula but it seems to give differing results based on whether Excel 2007 or 2010 is used:

Refer to file "dip11 error test" for a small sample of the data to figure out if you can correct his formula to work with 2010.

## Bookmarks