Elapsed times that cross midnight.

I want to be able to find the intervals between eruptions of Old Faithful Geyser. No big deal substract the previous eruption start time from the current eruption start time. The problem comes when the previous eruption was say at 2245 (military time) and the current eruption time is 0010 I get the ##### signs of death. I should get 85 minutes. The only formula I found didn't work correctly.

I would appreciate any guidance.

Fay

Moderator note: As you are a new member I have changed the title of your thread for you this time. Please see note below.

Try this

Please Login or Register  to view this content.

With B1 is current time and A1 is previous time.
Please note that the formula result is TIME value. If you want to convert to minutes, please multiply the result by 1440.

Administrative Note:

FayY welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Moderator note: Since you are new to the forum I will change it for you this time as a courtesy.