How Hard Can This Be? - Time Difference

[saphite]

I have two text boxes.

In one, I am entering a start time. In this case, it is a 24 hour
time, which is "16:00"

In the other, I am entering an end time. In this case, which will be
"00:00", which is twelve midnight.

The question is, how do i find the difference of these two times in
the "hh:mm" format.

Every solution i've tried(and i've been searching and searching for 1
and 1/2 hours) gives me either -16 hours, or a data type error.

I am ripping my hair out. I have a deadline of two days and I cannot
get past this.

Please help quickly.

[Vincent]

On Aug 25, 2:05 pm, saphite <[e-mail]:

I have two text boxes.

In one, I am entering a start time. In this case, it is a 24 hour
time, which is "16:00"

In the other, I am entering an end time. In this case, which will be
"00:00", which is twelve midnight.

The question is, how do i find the difference of these two times in
the "hh:mm" format.

Every solution i've tried(and i've been searching and searching for 1
and 1/2 hours) gives me either -16 hours, or a data type error.

I am ripping my hair out. I have a deadline of two days and I cannot
get past this.

Please help quickly.

But 16 is correct (datediff("h", "00:00", "16:00") = 16). The
difference between midnight and 4pm is 16 hours.

Vincent

[missinglinq via AccessMonster.com]

"Well, since the date is not integral to my calculation, I would say
it's a little "workaroundish"."

In point of fact, the date *is* integral to your calculations, which is why
you're having so much trouble, because you're trying to ignore this fact!
*Time* simply does not exist independent of date! 16:00 today *is not* the
same as 16:00 tomorrow!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com