how can i get the result of two time.

Posted on 2003-11-11
Last Modified: 2010-04-06
how can i get the result of two time.

7:05 AM - 8:30 AM
5:48 PM - 7:30 PM

Question by:ziaguintu6
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +2
LVL 12

Expert Comment

by:Dean OBrien
ID: 9721202
what language
LVL 35

Expert Comment

ID: 9721922
VBScript example:

use DateDiff function.
DateDiff(interval, number, date)
Where interval could be one of those:

h      ---> Hour
n      ---> Minute
s      ---> Second

Dim diffInMinutes, diffInSec
diffInMinutes=DateDiff("n",8:30, 7:05)
diffInSec=DateDiff("n",8:30, 7:05)

LVL 15

Expert Comment

ID: 9721931
Do you mean you want the difference between the two times?

In Java:

        Calendar startTime = Calendar.getInstance();
        startTime.set(2003, 10, 11, 7, 5);
        Calendar endTime = Calendar.getInstance();
        endTime.set(2003, 10, 11, 8, 30);
        long diff = endTime.getTimeInMillis() - startTime.getTimeInMillis();
        System.out.println("diff = " + diff);

This give 5100000 (5100 seconds = 85 minutes = 1 hour 25 minutes).

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 11

Expert Comment

ID: 9726234

var today = new Date();
var year = today.getFullYear();
var month = today.getMonth();
var day = today.getDay();

var start = new Date(year, month, day, sHours, sMinutes, sSeconds).getTime();
var end = new Date(year, month, day, eHours, eMinutes, eSeconds).getTime();

//  you supply the hours, minutes, seconds for each

var diff = (end - start) * 1000; //  difference in seconds
var diffHours = Math.floor(diff / 3600);
var diffMinutes = Math.floor( (diff - (diffHours * 3600)) / 60 );
var diffSeconds = Math.floor(diff - (diffHours * 3600) - (diffMinutes * 60));


$start = mktime($s_hours, $s_minutes, $s_seconds);
$end = mktime($e_hours, $e_minutes, $e_seconds);

# you supply the hours. minutes, seconds for each

$diff = $end - $start;

$diff_formatted = date("G:i:s", $diff);

MySQL (pre-4.1.1):

SELECT DATE_SUB("2003-11-12 17:42:35", INTERVAL "12:30:20" HOUR_SECOND) AS difference;

(version 4.1.1 and higher)

SELECT SUBTIME("17:42:35", "12:30:20") AS difference;

Author Comment

ID: 9727236
i am using asp and i can't understand your answer. i assigned the two dates from two variables

LVL 15

Expert Comment

ID: 9727540
LOL: About the only thing no one covered ;-)

I can't help with that :-(
LVL 11

Accepted Solution

Zontar earned 25 total points
ID: 9727693
Well, you could just use JScript for your ASP (and the code I posted above). But since I enjoy suffering, here it is in ASP/VBScript ... ;^)

  Time1 = TimeValue("3:45:30AM")
  Time2 = TimeValue("5:25:40PM")

  H1 = Hour(Time1)
  M1 = Minute(Time1)
  S1 = Second(Time1)

  H2 = Hour(Time2)
  M2 = Minute(Time2)
  S2 = Second(Time2)

  Diff = TimeSerial(H2 - H1, M2 - M1, S2 - S1)

  HD = Hour(Diff)
  MD = Minute(Diff)
  SD = Second(Diff)

  Response.Write HD & ":" & MD & ":" & SD
  ' Displays: 13:40:10
LVL 35

Assisted Solution

YZlat earned 25 total points
ID: 9731060
Dim diffInMinutes, diffInSec
diffInMinutes=DateDiff("n",8:30, 7:05)
diffInSec=DateDiff("n",8:30, 7:05)

LVL 35

Expert Comment

ID: 9731065
The diffInMinutes=DateDiff("n",8:30, 7:05)
 will return the difference in minutes and diffInSec=DateDiff("n",8:30, 7:05)
will return the difference in seconds
LVL 11

Expert Comment

ID: 9732228
I didn't realise you could pass DateDiff a dummy argument like that, thanks for the tip.

I usually do all my ASP stuff in JScript (or occasionally ActivePython) and only use VBScript when someone holds a gun to my head. ;^)

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Field that has HTML displays the code instead of the text in html 16 122
website content maintenance 3 136
JQuery tracking event. 3 90
Questions about this React unit test 4 77
What is Node.js? Node.js is a server side scripting language much like PHP or ASP but is used to implement the complete package of HTTP webserver and application framework. The difference is that Node.js’s execution engine is asynchronous and event…
I found this questions asking how to do this in many different forums, so I will describe here how to implement a solution using PHP and AJAX. The logical flow for the problem should be: Write an event handler for the first drop down box to get …
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

738 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