Can you amend this formula?

  • Thread starter Thread starter Gadgetman
  • Start date Start date
G

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
 
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
 
Back
Top