Time Calculations..subtracting Minutes

[JHB]

Hi:

I am developing a driver scheduling package, and have a couple of time
calculation related questions.

In on cast I have the start time for an appointment, and the time the
appointment is expected to take (in minutes) and I am trying to
determine how to produce a calculated field with the time someone has
to be collected from the appointment. I have another situation where I
know the time someone has to arrive at a specific place and the time
it will take to get there, and am trying to calculate the time a diver
has to start off.

The same calculation principal is appropriate for both I am sure.

Can someone help[ me with the following;

What format should the basic time be in?
I plan to have a form input field which contains the number of minutes
to be added or subtracted. Can someone give me the formula to subtract
(or add) this field to the base time and store it in a new field,
please.

Help of any sort would be much appreciated!!!


Regards

John Baker

 

[Phil Hunt]

Look up DateDiff function

 

[John W. Vinson]

Hi:

I am developing a driver scheduling package, and have a couple of time
calculation related questions.

In on cast I have the start time for an appointment, and the time the
appointment is expected to take (in minutes) and I am trying to
determine how to produce a calculated field with the time someone has
to be collected from the appointment. I have another situation where I
know the time someone has to arrive at a specific place and the time
it will take to get there, and am trying to calculate the time a diver
has to start off.

The same calculation principal is appropriate for both I am sure.

Can someone help[ me with the following;

What format should the basic time be in?
I plan to have a form input field which contains the number of minutes
to be added or subtracted. Can someone give me the formula to subtract
(or add) this field to the base time and store it in a new field,
please.

Help of any sort would be much appreciated!!!


Regards

John Baker

DateAdd("n", <number of minutes>, <base time>)

For example

?now;dateadd("n", -200, now)
3/15/2012 5:51:53 PM 3/15/2012 2:31:53 PM
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[JHB]

Hi:

I am developing a driver scheduling package, and have a couple of time
calculation related questions.

In on cast  I have the start time for an appointment, and the time the
appointment is expected to take (in minutes) and I am trying to
determine how to produce a calculated field with the time someone has
to be collected from the appointment. I have another situation where I
know the time someone has to arrive at a specific place and the time
it will take to get there, and am trying to calculate the time a diver
has to start off.

The same calculation principal is appropriate for both I am sure.

Can someone help[ me with the following;

What format should the basic time be in?
I plan to have a form input field which contains the number of minutes
to be added or subtracted. Can someone give me the formula to subtract
(or add) this field to the base time and store it in a new field,
please.

Help of any sort would be much appreciated!!!

John Baker

DateAdd("n", <number of minutes>, <base time>)

For example

?now;dateadd("n", -200, now)
3/15/2012 5:51:53 PM 3/15/2012 2:31:53 PM
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com

Thank you all very much..That is exactly what I needed!!!

John Baker