Formula calculate the amount of late bookings

**Massy1983** · 09-30-2010, 06:35 AM

Hi

I am trying to come up with a formula where:

A booking made for a journey which needs to be completed on the same date or is made the day before but AFTER 13:00hrs will display in a set field as NO. If the booking had been made before 13:00hrs the day before the booking then the cell would display YES.

We have journey dates in a column and also booked date of journey. What i am looking to achive is that if a booking is made the date before the date of the journey but has been made before the hours of 13:00hrs this will show yes and for after 13:00hrs would show no. Im looking to calculate the amount of late bookings we recieve.

Hope you can help

**pike** · 09-30-2010, 06:43 AM

Hi Massy1983
Welcome to the forum
Please take a few minutes to read the forum rules, and then amend your thread title accordingly

**Massy1983** · 09-30-2010, 06:53 AM

Thanks Pike for the fast response.

I have heard VBA is quite complexed. Do you think i woould need to go doen this line or would a formula be good enough?

**DonkeyOte** · 09-30-2010, 07:01 AM

Presumably the Journey Dates are just Dates whereas the Booking values are DateTime values, correct ?

One method might be:

=IF(A2>=B2-"11:00","NO","YES")

where B2 holds Journey Date and A2 holds Booking DateTime

**Massy1983** · 09-30-2010, 07:12 AM

Hi Donkeyote

many thanks for the reply
A2 will hold date and time booking made
B2 will just hold journey date

so any bookings made for a journey on the same day or day before (but afrter the hours of 13:00) will display No or Late booking.

All bookings made 13:00hrs or before on the day before or sooner will display yes or non late booking

what do you think the formula will be for this?

Many thanks

**DonkeyOte** · 09-30-2010, 07:16 AM

Originally Posted by Massy1983

what do you think the formula will be for this?

the one posted previously

**pike** · 09-30-2010, 06:59 AM

Hi Massy1983,
I've changed your title, please revise the forum rules so you can comply in the future.
In the forum rules you can also read about how best to have your questions answered.
Attaching workbook would be help full in understanding your request

**pike** · 09-30-2010, 08:13 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save