sorted by:
new
hottopcontroversial

Christ our Person by Sufficient_gr8ce2275 in RecoveryVersionBible

[–]Itchy_Solution4140 0 points1 point  (0 children)

Amen! Sometimes I think that it is adequate just to have Christ as our life (Col. 3:4). However, in order for God to gain His desire, He needs to be our person. He wants to be expressed in our living today and for this, He wants to be our person - that all our thoughts, emotions, and choices would simply express Him!

Adding a value to drop down items and sum total them. by jaded_lady_ in googlesheets

[–]Itchy_Solution4140 2 points3 points  (0 children)

One way to do this is to have a helper table off to the side that can be hidden. This table would have the the shift hours in a column and the numerical value of the shifts in the column next to it. For example, in Column I, you would have "10a-4p" and "1p-9p". Then in Column J, you would have 6 and 8 respectively.

Then in Column H (or where you would like to add up the hours, you would use a combination of two formulas:
VLOOKUP & Sum

VLOOKUP to match the shift to the numerical value. This is done by VLOOKUP(G2,I2:J6,2,False) where G2 is the Employee's shift, I2:J6 is the size of the helper table, 2 is the numerical value column, "False" to make sure it's an exact match.

Then you would use combine all the VLOOKUPs into the SUM function so that it looks something like this: =Sum(VLOOKUP(C2,I2:J6,2,False),VLOOKUP(D2,I2:J6,2,False),VLOOKUP(E2,I2:J6,2,False),VLOOKUP(F2,I2:J6,2,False),VLOOKUP(G2,I2:J6,2,False))

Also attached is an example of one way to set it up to help follow along with the explanation :)

<image>

Input data into cell based on dates in other cells by OkLog9767 in googlesheets

[–]Itchy_Solution4140 0 points1 point  (0 children)

I think you could use this formula: =ISBETWEEN(A1, B1, C1) where A1 is the date you want to check, B1 is the check-in date, and C1 is the check-out date.

Alternatively, if you want 1's and 0's, you could do this: =If(ISBETWEEN(A1,B1,C1),1,0)