Can you amend this formula?

[Gadgetman]

I have this formula on my worksheet to distinquish if cell E value i
between the hours of midnight and 7.00 am it would add 1 to the cel
G.

=IF(AND(E4>="0:00"+0,E4<="7:00"+0),F4+1,"")

Cell (E:4) shows the time in 24hour format.
Cell (F4) shows the cost
Cell (G:4) shows the cost of Cell (F:4) + 1 if Cell (E4) = 00:00 am t
07:00 am

How do I amend this formula so that the result appears in every cell i
column G as I move down the list.

Thanks

 

[Frank Kabel]

Hi
if I understood you correctly just copy this formula down

 

[Gadgetman]

Sorry Frank but you left out your formula

 

[Frank Kabel]

Hi
I thought your formula is quite o.k. but you may try this small
addition
=IF(AND(E4>="0:00"+0,E4<="7:00"+0,E4<>""),F4+1,"")
copy this formula down for all rows

 

[Gadgetman]

Thank you Frank