I am trying to create an IF function that when a parent signs in their child if the number falls betweens certain times they are charged a certain amount. For example, there is a 1 hour min. so if the child comes at 2:35pm and clocks out at 3:25pm they are charged for 1 hour. After the 1 hour min. they are charged every half hour. So I want to calculate the billable amount. I used this formula and it is not working, I hope I am close.
=IF(G3=0,"0",IF(K1<=G3<=L1,"1",IF(K2<=G3<=L2,"1.5",IF(K3<=G3<=L3,"2",IF(K4<=G3<=L4,"2.5",IF(K5<=G3<=L5,"3",IF(K6<=G3<=L6,"3.5",IF(K7<=G3<=L7,"3.75","10"))))))))
=IF(G3=0,"0",IF(K1<=G3<=L1,"1",IF(K2<=G3<=L2,"1.5",IF(K3<=G3<=L3,"2",IF(K4<=G3<=L4,"2.5",IF(K5<=G3<=L5,"3",IF(K6<=G3<=L6,"3.5",IF(K7<=G3<=L7,"3.75","10"))))))))