<div>
try using different variable names, especially for Time as that is a reserved word
</div>


<div>
Between 9:58 AM and 8:57 PM, it is one minute shy of 11 hours. I think the difference should be 659 minutes. Why do you think it ought to be 780?<br />
<br />
Just for grins, I ran the code in Excel VBA, and it agreed with my arithmetic expectations.
</div>


<div>
<blockquote>
Between 9:58 AM and 8:57 PM, it is one minute shy of 11 hours. I think the difference should be 659 minutes. Why do you think it ought to be 780?
</blockquote>
when ran at 8:57PM is about 13 hours from 9:58Am<br />
13x60 = 780 minutes
</div>


<div>
<blockquote>
try using different variable names, especially for Time as that is a reserved word
</blockquote>
i will give it a try, good thought
</div>


<div>
I disagree. 13 hours would be 10:58 PM.<br />
<br />
Surely you would agree that 9:58 AM to 9:58 PM would be exactly 12 hours. And 9:58 PM to 9:58 AM the next day would be another 12 hours.
</div>


<div>
<blockquote>
try using different variable names, especially for Time as that is a reserved word
</blockquote>
changed Time to ITime<br />
made no difference
</div>


<div>
Thanks that fixed the issue
</div>


<div>
<div class="content wysiwyg-content">
Dim Time As String<br />
Time = &quot;09:58 AM&quot;<br />
<br />
Minutes = DateDiff(&quot;n&quot;, Time, Format(Now, &quot;short time&quot;))<br />
when ran at 8:57PM <br />
the minutes say 661, but should be 780 <br />
what is wrong ?
</div>
</div>


Dim Time As String
Time = "09:58 AM"

Minutes = DateDiff("n", Time, Format(Now, "short time"))
when ran at 8:57PM 
the minutes say 661, but should be 780 
what is wrong ?

Time difference giving incorrect results vb 6

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.