Time Value Multiplied for Round Trip Calculation

[LRay67]

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??

 

[Daryl S]

LRay67 -

Double the difference in time before formatting. Like this:

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