If condition satisfied but ignored

OK this is annoying me.
The If condition is satisfied but jumps to the next one where the (O_Hrs + Time_Acc >8) when in fact it satisfies the (O_Hrs + Time_Acc <=8)

What on earth am i missing.

Please Login or Register  to view this content.

VBA If condition fail.png

Originally Posted by remkin76

OK this is annoying me.
The If condition is satisfied but jumps to the next one where the (O_Hrs + Time_Acc >8) when in fact it satisfies the (O_Hrs + Time_Acc <=8)

Are you sure it is being satisfied? Hard to say for sure without seeing any data, but if you are testing a REAL time against 8, then this is probably where you are getting mixed up.

What you need to understand about dates and times in excel is…

a date is just a number representing the number of days passed since 1/1/900...and then formatted in a way that we recognize as a date. So, for instance, today (Tue 09 Jul 2019) is actually 43655

Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75

So, having said all that, 8 (am) is actually 0.333 and 8 (pm) is really 0.666

Pics are often hard to make out. I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.