Your problem is that you set 16:30 to variable
dtShifTime
, and then you use
dtLateTime
when comparing.
dtLateTime
is not defined in this code.
Use the debugger to see the values of variables at runtime.
Your code do not behave the way you expect, or you don't understand why !
There is an almost universal solution: Run your code on debugger step by step, inspect variables.
The debugger is here to show you what your code is doing and your task is to compare with what it should do.
There is no magic in the debugger, it don't know what your cpde is supposed to do, it don't find bugs, it just help you to by showing you what is going on. When the code don't do what is expected, you are close to a bug.
To see what your code is doing: Just set a breakpoint and see your code performing, the debugger allow you to execute lines 1 by 1 and to inspect variables as it execute.
Debugger - Wikipedia, the free encyclopedia[
^]
Mastering Debugging in Visual Studio 2010 - A Beginner's Guide[
^]
Basic Debugging with Visual Studio 2010 - YouTube[
^]
Visual Basic / Visual Studio Video Tutorial - Basic Debugging - YouTube[
^]
Visual Basic .NET programming for Beginners - Breakpoints and Debugging Tools[
^]
Debugging in Excel VBA - EASY Excel Macros[
^]
MS Excel 2013: VBA Debugging Introduction[
^]
How to debug Excel VBA - YouTube[
^]
The debugger is here to only show you what your code is doing and your task is to compare with what it should do.
Quote:
I'm already using debugger for find How the code works but i've no idea for which condition to check Time difference because some condtitions applied
Since you work on hours only, you have a set of condition in the day, and another one when you change of day in the shift.