**Question description:**

*This user has given permission to use the problem statement for this blog.*

HI I need help with an If and and statement formula... for some reason it's not working for me

Solved by V. U. in 26 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
07/09/2017 - 05:57

hello , i was using the formula if and and but its not working i was using this formula on column F

User
07/09/2017 - 05:57

=if(and(e2=1,d2<=b2),1,0)

User
07/09/2017 - 05:58

I want to confirm that the person who arrived during their appt date also arrived on time by time

User
07/09/2017 - 05:58

im sorry the formula i was using actually looks like this

User
07/09/2017 - 05:58

=if(and(e2=1,d2<=b2+30),1,0)

User
07/09/2017 - 05:59

I was giving them a 30 minute grace period to arrive, other wise it would be late

Excelchat Expert
07/09/2017 - 05:59

let me check, please give me a moment

User
07/09/2017 - 05:59

ok

User
07/09/2017 - 06:06

?

Excelchat Expert
07/09/2017 - 06:08

I am working on it

Excelchat Expert
07/09/2017 - 06:08

give some time

User
07/09/2017 - 06:10

ok

Excelchat Expert
07/09/2017 - 06:15

Ok

Excelchat Expert
07/09/2017 - 06:15

You can't add integer directly to time formula

Excelchat Expert
07/09/2017 - 06:16

if you want to add hrs in time then you have to first divide your number (in this case its 30) with 24 and then add it

Excelchat Expert
07/09/2017 - 06:17

if you want to add seconds then divide the number with 1440

Excelchat Expert
07/09/2017 - 06:18

Sr if you want to add minutes then divide the number with 1440

Excelchat Expert
07/09/2017 - 06:18

and if you want to add seconds then divide the number with 86400

Excelchat Expert
07/09/2017 - 06:19

i suggest you first divide the number (if hrs then 30/24) in seperate cell and change the format of the cell to time and then use that cell in the formula

Excelchat Expert
07/09/2017 - 06:20

it is the best and the easiest way to solve this type of problem

Excelchat Expert
07/09/2017 - 06:20

please confirm if i gave you the right solution

Excelchat Expert
07/09/2017 - 06:21

Thanks for using Got It Pro-Excel Please give your kind feedback for our service Have a good day ahead

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*