Cells Dependent but non changing after filled even when dependent cell changes

[whytewolves]

This Color is the only Cells info input in

Car1

Car2

Car3

Car4

Start:

Auto Fill (B2:E2)Based on (L3) (12593.1)

sum(Miles)

Time Clocked in (Military)

Tuesday 12/13/2022 07:45

Count Shop

Count Delv

Sum(Base)

Sum(peak)

Sum(tip)

sum(paid)

1234.6

4987.5

12593.1

9167.8

End:

Input (12637.8)

(t2/i2)

Time Clocked out (Military)

This color are the cells I need help with

Auto Fill (B3:E3) when (H2) End input and go blank when B2:E2 = this ending total

12637.8

City:

Car3:

Auto Fill Total Miles when (H2) input

B3-B2

C3-C2

D3-D2

E3-E2

AcTime

Date

Year

City

Week

Auto

Day

Miles

Time

Offer

Store

Customer

Arrv

Shop

Delv

Base

Peak

Tip

Paid

Comment

Completed

Auto fill Delv - Time

Auto Fill when Miles is input (12/12/22)

iferror year (c6)

Auto Fill (k3) when Miles input

iferror weeknum (c6)

Auto Fill (l3) when miles input

iferror text (c6,"dddd")

Input estimated miles (2.4)

Auto Fill Military Time when Miles input

Input $ Amt

Data Validation Based on City

Data Valudation Based on City

Input Military Time

Input Military time Min:sec only

Input military Time

Input Pay Amt

Auto Fill based on Time/Date and DO NOT change once filled in

Input Amt

Auto Fill if (Q6<>"",if(t6="",q6+r6+s6),"")

Auto Fill "Active" when Miles input. Data Validation "Done" & "Cancelled" which will COPY row but not formulas to Completed sheet

NOW

PEAK

Start

End

Amt

5:00

11:00

$ 2.00

11:30

13:29

$ 1.00

13:30

15:29

$ 1.50

17:30

19:29

$ 1.00

19:30

21:29

$ 2.50

Times and amounts will vary day to day and somedays there will be none