469,271 Members | 1,000 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

Working with time (dateDiff)

Hi,

I'm having trouble working out the best way of calculating the time
difference between two times on the same day.
The example I have found does return the hours (in this case 8) but forgets
the minutes.

I am looking to return the hour & the minute but i've had a look at the
dateDiff format and this doesn't seem possible ?

Thanks

J.
---------------------------------
time1 = "09:15"
time2 = "17:30"
hours = datediff("h",time1,time2) ' in hours

response.write(hours)
----------------------------------
Jul 22 '05 #1
4 11448
"John Smith" wrote ...
I am looking to return the hour & the minute but i've had a look at the
dateDiff format and this doesn't seem possible ? hours = datediff("h",time1,time2) ' in hours


hours = datediff("m", time1, time2) ' in minutes

hours = hours / 60

its rough...

Rob
Jul 22 '05 #2
"John Smith" wrote ...
---------------------------------
time1 = "09:15"
time2 = "17:30"
hours = datediff("h",time1,time2) ' in hours

response.write(hours)
----------------------------------


So - in the above - hours = 8 and the minutes are lost...

hours = datediff("n", time1, time2) ' in minutes
' hours would now =
Jul 22 '05 #3
"John Smith" wrote ...
---------------------------------
time1 = "09:15"
time2 = "17:30"
hours = datediff("h",time1,time2) ' in hours

response.write(hours)
----------------------------------


Hi John,

Please excuse my first post which I placed an m for minutes instead of the
n - please then excuse my second post which I sent to early prior to
finishing a code example...

Try this!

<%
time1 = "09:15"
time2 = "17:30"

' minutes = datediff("n",time1,time2) ' in minutes
' response.write(hours)

hour1 = hour(time1)
hour2 = hour(time2)

minutes1 = "00:" & minute(time1)
minutes2 = "00:" & minute(time2)

hoursDiff = datediff("h", time1, time2)
minutesDiff = datediff("n", minutes1, minutes2)

If minutesDiff > -1 Then

' positive hour difference
timeDiff = hoursDiff & "hrs " & minutesDiff & "mins"

Else
' negative hour difference
hoursDiff = hoursDiff - 1
minutesDiff = 60 + minutesDiff

timeDiff = hoursDiff & "hrs " & minutesDiff & "mins"

End If

Response.Write timeDiff
%>

Give the above ago - then try changing it so that the minutes of time2 are
less than the minutes of time1 - still works nicely - you'll need to play
with different times to test it fully I'm sure there's still an opportunity
here for error in the above.

Hope this helps.

Regards

Rob
Jul 22 '05 #4
"John Smith" <jo**@smith.com> wrote in message
news:cs**********@sparta.btinternet.com...
Hi,

I'm having trouble working out the best way of calculating the time
difference between two times on the same day.
The example I have found does return the hours (in this case 8) but forgets the minutes.

I am looking to return the hour & the minute but i've had a look at the
dateDiff format and this doesn't seem possible ?

Thanks

J.
---------------------------------
time1 = "09:15"
time2 = "17:30"
hours = datediff("h",time1,time2) ' in hours

response.write(hours)
----------------------------------


Const time1 = "09:15"
Const time2 = "17:30"
Dim hours, mins
hours = datediff("h",time1,time2)
mins = datediff("n",time1,time2)
If mins > 60 Then mins = mins - hours * 60
response.write hours & ":" & mins
Jul 22 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by androtech | last post: by
3 posts views Thread by John McGinty | last post: by
2 posts views Thread by wireless200 | last post: by
6 posts views Thread by Mark Reed | last post: by
2 posts views Thread by John | last post: by
10 posts views Thread by Drum2001 | last post: by
19 posts views Thread by DonLi2006 | last post: by
15 posts views Thread by student4lifer | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.