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.
Bookmarks