time function

  • Thread starter Thread starter J Taylor
  • Start date Start date
J

J Taylor

hi,
I have a very simple table with exam starttime and endtime.
This is in the format of short time ie 09.15. I need to be
able to add extra time onto the starttime for students
with disabilities. This will vary accordingly, but is in
the form of a percentage. Using datediff I have calculated
the total exam time in minutes and can multiply this time
by the required amount. I then need to add this amount of
minutes onto the starttime to produce the new endtime,
which needs to be in the short date format. Is this
possible - or am I going about this in the wrong way.
I would appreciate any help.

cheers
 
Look at the DateAdd function which is a counterpart of the DateDiff function

DateAdd("m", YourCalculationResults,StartTime)
 
Thanks - thats worked a treat. Cheers Jane
-----Original Message-----
Look at the DateAdd function which is a counterpart of the DateDiff function

DateAdd("m", YourCalculationResults,StartTime)




.
Click to expand...
 
Back
Top