Suggestions for an auto-sum problem (that's probably quite simple!)

[johnnymercer74]

Hello there. I'm making a simple worksheet for a friends gliding club. It shows how long they've flown for on a list of sequential days and also lists against each day, the number of lost events (ie they couldn't fly for some reason) in two columns, weather and mechanical. (See attached image).

I'm trying to think of a way that I can automatically get the worksheet to calculate 'time since last lost event". Ideally the worksheet would sum the duration listed against each day starting the day after a lost event has been recorded.

I've made it sound quite complicated but I'm sure if you are quite experienced on Excel/VB, you'll probably scoff at how easy this is.

Any help is appreciated, sorry I could only upload an image of the worksheet, I can email a copy of it helps.

John