Formula request please

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

Gadgetman

Hi

What formula would I need to write in cell (G:4), which will add 1 t
cell (G:4), if the time in (E4) is between 00:00 hours and 07:00 hour


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

Required Example:

E4 F4 G4
Time Cost Extra
01:30 am £2.00 £3.00
22:00 pm £2.00 £2.00
03:30 am £4.00 £5.00


Thank
 
Hi
try in G4
=IF(AND(E4>=0,E4<=7/24),F4+1,F4)

or a little bit shorter
=F4 + (E4>=0)*(E4<=7/24)
 
Back
Top