OFFSET Drag down not working as intended

[Atlantir]

Hi! So I'm trying to make an excel for a shift schedule and currently i have a problem with the offset formula, the formula itself works fine but I don't know how to make it work when draging down, here is the formula:
=OFFSET(march!$B$1,16,0,1,1)-OFFSET(march!$B$1,15,0,1,1)
I want the offset to get values from different sheet where the workers can manually insert hours and how they were working so it need to go down by 3 with each cell for an example

Jacob Remote
Start 9
End 17
Michael Office
Start 10
End 16

So i need the offset to go with each cell down by 3 i tried using ROW()-3 but it is not working as i wanted to. I know that i didn't explained it well but i hope you will know what I mean if not i will try to post images from the sheet because i have it on my laptop from work.

 

[GraH]

Not sure to get your use case, but maybe this can help?

Book1
	B	C	D	E	F	G	H	I	J	K
1
2		Jacob	Remote			Jacob	17	9
3		Start	9			Michael	16	10
4		End	17			Jordan	12	8
5		Michael	Office
6		Start	10
7		End	16
8		Jordan	Customer
9		Start	8
10		End	12
11
Sheet1

Cell Formulas
Range	Formula
H2:H4	H2	=OFFSET($C$2,3*COUNTA($G$2:G2)-1,1)
I2:I4	I2	=OFFSET($C$2,3*(COUNTA($G$2:G2)-1)+1,1)

 

[Atlantir]

Hi! So now I can post screens how does it all look and also I made small changes so I think it will be easier to make formulas here. First of all I want to make the excel count how many SL anyone had, if excel will find that in cell X is a sick leave then it will add 8 hours to a total of sick leaves, if they were working, it will add how many hours they were working, if it will find that they were on holidays it will add 8 hours to total of holidays. Also I found an issue where I type marchA2-marchA1 in a cell to count Adrian hours and it works fine then I do the same for Jakub (A4-A3) and after doing that and selecting them to drag it down the rest of the cells is looking something like:
A2-A1
A3-A2
A4-A3
So instead of jumping down by 2 it just moves only by one. will OFFSET function work there?


That's how the work schedule sheet looks like

And that's how the hours sheet looks like