Advertisement

01.18.2008 at 04:53PM PST, ID: 23095050
[x]
Attachment Details

calculate the time difference between two times in hours and minutes

Asked by JDEE8297 in Microsoft Visual Basic.Net

Tags:

Greetings,

I am trying to write an application where I can keep track of the time worked during the day. Say I entered in 7:03am and finished at 12:21pm and then back 1:21pm and finished for the day at 5:30pm. I would like it calculate the total time worked and time taken for lunch and store that in a database.

I tried searching for this on the web for some sample code, but none seem to do exactly what i am looking for, I know it is using the datediff function in some shape or form. so any help would be appreciated. Thanks.

        Dim strStart As String = "7:21:00 AM"
        Dim strEnd As String = "12:59:00 PM"

        MsgBox(DateDiff(DateInterval.Hour, CDate(strStart), CDate(strEnd)))
        MsgBox(DateDiff(DateInterval.Minute, CDate(strStart), CDate(strEnd)))

When I try to do it with the code above, I get mixed results. May be what I want is not possible, but I would think this is something that can be done, but but I am either looking in the wrong place or something else.Start Free Trial
 
Loading Advertisement...
 
[+][-]01.18.2008 at 05:15PM PST, ID: 20695538

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]01.18.2008 at 06:13PM PST, ID: 20695718

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Visual Basic.Net
Tags: vb.net
Sign Up Now!
Solution Provided By: GeneM
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628