Carrying over total for only one month

[Bikerb]

Hi,

I have set up a workbook to record flexi-time earned and taken. Any outstanding earned flexi-time can be carried over to the next month, but only for one month, so if you have a balance of, say, one hour that you earned in January, you can use it in February, but if it's still outstanding at the end of February, it is lost. Does anyone know the formula I would need to incorporate into (possibly) the 'carried over' cell to accommodate this? Thank you.

 

[jproffer]

Are carried over hours from each month in a different column? I.E. -| Jan | Feb | Mar | Apr | etc?

Or even better yet, at the bottom of this post in my signature is a link to an addin that you can use to post your worksheet (not the file, just whatever you highlight) to this board, then we can see what you're looking at.

If you post the original, and then post what you expect to see out of this formula, even if you have to put it in manually for now, that would be a huge help.

To use the addin after it's loaded, you simply select all the cells you want to post here (I usually put borders around them all, but it's not required), right click and at the bottom you will see your choices (show all formulas, show one formula, etc.)...click what you want and at that point it is "copied" and ready to paste into your message here...it will look like this when posted (not in the post editor, but after you post it...in the editor it looks like a bunch of gibberish ...html code). Anyhow, looks like this when posted:

Excel 2013/2016
	A	B	C
1	BikerB	Hi BikerB	Hi BikerB
Sheet1

Cell Formulas
Range	Formula
C1	=B1

 

[Bikerb]

Hi jproffer, Thank you for getting back to me. Unfortunately, I am not able to undertake downloads to the computer I am using. I did, however, after much more head-scratching, manage to create a formula that seems to work by using (for example, in June) the total of May's hours as the 'carried over' figure, minus the cell containing April's carried over figure appearing in May. I apologise if this makes no sense (I'm a forum newbie). If my calculation does not, in fact, work, I should be able to download your add-in at a later date on a different computer to provide more info. Thanks again.

 

[jproffer]

It's not my add-in . The site owners built that, I presume. At any rate, I'm glad you figured out how to make it work...I couldn't visualize what you were after.

The file it leads you to is a zip file with one excel (Xla) file inside...but I understand how work can be about things like that...even when you're trying to do something that will benefit THEM