Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 328
  • Last Modified:

how can i get the result of two time.

how can i get the result of two time.
sample

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

thanks
0
ziaguintu6
Asked:
ziaguintu6
  • 3
  • 3
  • 2
  • +2
2 Solutions
 
Dean OBrienCommented:
what language
0
 
YZlatCommented:
VBScript example:

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

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

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




0
 
jimmackCommented:
Do you mean you want the difference between the two times?

In Java:

        Calendar startTime = Calendar.getInstance();
        startTime.clear();
        startTime.set(2003, 10, 11, 7, 5);
        Calendar endTime = Calendar.getInstance();
        endTime.clear();
        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).

0
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!

 
ZontarCommented:
JavaScript:

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));

PHP:

$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;
0
 
ziaguintu6Author Commented:
i am using asp and i can't understand your answer. i assigned the two dates from two variables

thanks
0
 
jimmackCommented:
LOL: About the only thing no one covered ;-)

I can't help with that :-(
0
 
ZontarCommented:
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
%>
0
 
YZlatCommented:
<%
Dim diffInMinutes, diffInSec
diffInMinutes=DateDiff("n",8:30, 7:05)
diffInSec=DateDiff("n",8:30, 7:05)

%>
0
 
YZlatCommented:
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
0
 
ZontarCommented:
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. ;^)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 3
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now