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 