DateAdd

[Wer]

Hi,

I'm trying to add hours together in the format HH:MM + HH:MM. There
doesn't seem to be a functional part of DateAdd that will accomplish
this though ?

The calculation is to work out how many hours have been spent on a
website so exceeding the 24:00 is fine.
Is there another function that would accomplish this ?

Thanks

W.

[Bob Barrows [MVP]]

Wer wrote:

Hi,

I'm trying to add hours together in the format HH:MM + HH:MM. There
doesn't seem to be a functional part of DateAdd that will accomplish
this though ?

The calculation is to work out how many hours have been spent on a
website so exceeding the 24:00 is fine.
Is there another function that would accomplish this ?

Thanks

W.

Use DATEPART to convert the datetime values to the appropriate resolution
and simply add them together arithmetically. You will need to create a
function to display the results in hh:mm format if that is required, because
that ability is not builtin. Google should provide many examples of doing
this. I would search for

vbscript format time duration hh:mm

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Ray Costanzo [MVP]]

How would it know if you go from 13:50 to 14:50 that you mean 1 hour, 25
hours, 49 hours, etc.? You have to include a date to avoid this ambiguity.

Ray at work

"Wer" <we*@tlcevents.co.uk> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Hi,

I'm trying to add hours together in the format HH:MM + HH:MM. There
doesn't seem to be a functional part of DateAdd that will accomplish
this though ?

The calculation is to work out how many hours have been spent on a
website so exceeding the 24:00 is fine.
Is there another function that would accomplish this ?

Thanks

W.

[Evertjan.]

Wer wrote on 31 jan 2005 in microsoft.public.inetserver.asp.general:

I'm trying to add hours together in the format HH:MM + HH:MM. There
doesn't seem to be a functional part of DateAdd that will accomplish
this though ?
Could be don but I prefer the hands on way below.
The calculation is to work out how many hours have been spent on a
website so exceeding the 24:00 is fine.
Is there another function that would accomplish this ?

Using vbscript:

time1 = "13:17"
time2 = "12:51"

time1a = split(time1,":")
time2a = split(time2,":")

mi = 1*time1a(1) + 1*time2a(1)
hr = 1*time1a(0) + 1*time2a(0)

if mi>59 then mi = mi-60 : hr = hr+1

response.write hr & ":" & two(mi) ' writes 26:08

function two(x)
if x<10 then x = "0" & x
two = x
end function

--
Evertjan.
The Netherlands.
(Replace all crosses with dots in my emailaddress)

[Evertjan.]

Ray Costanzo [MVP] wrote on 31 jan 2005 in
microsoft.public.inetserver.asp.general:

"Wer" <we*@tlcevents.co.uk> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Hi,

I'm trying to add hours together in the format HH:MM + HH:MM. There
doesn't seem to be a functional part of DateAdd that will accomplish
this though ?

How would it know if you go from 13:50 to 14:50 that you mean 1 hour,
25 hours, 49 hours, etc.? You have to include a date to avoid this
ambiguity.

Not the difference, Ray, but the sum was asked for.

They are just amounts of time to be added.
--
Evertjan.
The Netherlands.
(Replace all crosses with dots in my emailaddress)

[Ray Costanzo [MVP]]

My bad. :]

Ray at work

"Evertjan." <ex**************@interxnl.net> wrote in message
news:Xn********************@194.109.133.29...

Not the difference, Ray, but the sum was asked for.

They are just amounts of time to be added.
--
Evertjan.
The Netherlands.
(Replace all crosses with dots in my emailaddress)