Time Value Multiplied for Round Trip Calculation

  • Thread starter Thread starter LRay67
  • Start date Start date
L

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

Double the difference in time before formatting. Like this:

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