time function

[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

 

[John Spencer (MVP)]

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

DateAdd("m", YourCalculationResults,StartTime)

 

[Jane Taylor]

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)




.