Solved

VB.net - calculate time difference

Posted on 2013-06-04
4
480 Views
Last Modified: 2013-06-05
VB.net

Let say I have the two date/times:
6/4/2013 5:46:41 PM
6/4/2013 5:50:03 PM
=  3:22 seconds

6/4/2013 5:54:29 PM
6/4/2013 5:55:30 PM
= 0:59 seconds

How can I can calculate how many minutes and seconds between the two times?
0
Comment
Question by:keith1001
4 Comments
 
LVL 17

Expert Comment

by:Kent Dyer
ID: 39220814
Dateadd would do the trick.

If minutes = 0 then datrdiff s

HTH,

Kent
0
 
LVL 22

Assisted Solution

by:Thomasian
Thomasian earned 250 total points
ID: 39220878
        Dim d1 As Date = Date.Parse("6/4/2013 5:46:41 PM")
        Dim d2 As Date = Date.Parse("6/4/2013 6:50:03 PM")

        Dim ts As TimeSpan = d2.Subtract(d1)

        Dim s1 As String = ts.ToString  'hh:mm:ss
        Dim s2 As String = String.Format("{0}:{1}", Math.Floor(ts.TotalMinutes), ts.Seconds.ToString("00")) 'mm:ss

        MessageBox.Show(String.Format("{0}{1}{2}", s1, Environment.NewLine, s2))

Open in new window

0
 
LVL 75

Accepted Solution

by:
käµfm³d   👽 earned 250 total points
ID: 39220879
Subtracting two dates in .NET yields a TimeSpan instance. You can interrogate the TotalSeconds property of that instance.

e.g.

Dim firstDate As DateTime = DateTime.Parse("6/4/2013 5:46:41 PM")
Dim secondDate As DateTime = DateTime.Parse("6/4/2013 5:50:03 PM")

Dim diff As TimeSpan = (secondDate - firstDate)

Console.WriteLine(diff.TotalSeconds)

Open in new window

0
 
LVL 11

Expert Comment

by:SAMIR BHOGAYTA
ID: 39222002
hi.. you can try this

DateTime startTime = DateTime.Now;

DateTime endTime = DateTime.Now.AddSeconds( 75 );

TimeSpan span = endTime.Subtract ( startTime );
Console.WriteLine( "Time Difference (seconds): " + span.Seconds );
Console.WriteLine( "Time Difference (minutes): " + span.Minutes );
Console.WriteLine( "Time Difference (hours): " + span.Hours );
Console.WriteLine( "Time Difference (days): " + span.Days );

Output Like,

Time Difference (seconds): 15
Time Difference (minutes): 1
Time Difference (hours): 0
Time Difference (days): 0
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now