addition for last 90 days

[Green1972]

Hi All. i have a new question. I have to log my flight time so ive created a excell sheet to do this. as part of the competency i have to calulate totel flight time and flight time for the last 90days. So in column A i have the date (formatted 04/06/18) and in Colum G I have the flight duration (in minutes) for that date. What I want to do in column K is have the cell show the total flight time for the last 90 days from the last date in added in column A. How can I do it?

 

[FormR]

How do I put a screen capture on her to show you

Hi, there are a few methods described in this thread.

https://www.mrexcel.com/forum/about-board/508133-attachments.html

 

[Green1972]

HI All. Sorry for the delay in replying. Finally figured it out, my fault, I and not formatted all of the cells correctly, now it work fine. Thank you all for your help.