Prev: Continues Subforms Scrolling
Next: Change Label based on Two Combo Boxes
From: LRay67 on 30 Mar 2010 11:48
I have a form in which the user will be selecting how long it takes to get to
point B to point B using the following code:

=(DateDiff("n",[DriveHours1],[DriveHours2]))\60 &
Format((DateDiff("n",[DriveHours1],[DriveHours2])) Mod 60,"\:00")

What I need is to be able to multiply that time by 2 and come up with a
round trip total time. Any way to do this??


From: Daryl S on 30 Mar 2010 13:11
LRay67 -

Double the difference in time before formatting. Like this:

=Int(DateDiff("n",[DriveHours1],[DriveHours2])*2/60) & ":" &
(DateDiff("n",[DriveHours1],[DriveHours2])*2) Mod 60

--
Daryl S


"LRay67" wrote:

> I have a form in which the user will be selecting how long it takes to get to
> point B to point B using the following code:
>
> =(DateDiff("n",[DriveHours1],[DriveHours2]))\60 &
> Format((DateDiff("n",[DriveHours1],[DriveHours2])) Mod 60,"\:00")
>
> What I need is to be able to multiply that time by 2 and come up with a
> round trip total time. Any way to do this??
>
>
 | 
Pages: 1
Prev: Continues Subforms Scrolling
Next: Change Label based on Two Combo Boxes