Changing a range of time to intervals

[Cris Wesselman]

I am trying to figure out the following:

I have a segment of time, say 5:00 to 13:00 that also
contains the total number of minutes. What I need to do
is break it down so that it calculates the number of
minutes between 500-530, 530-600 and so on.

Any ideas?

 

[Larry Linson]

"Cris Wesselman" wrote

I am trying to figure out the following:

I have a segment of time, say 5:00 to 13:00 that also
contains the total number of minutes. What I need to do
is break it down so that it calculates the number of
minutes between 500-530, 530-600 and so on.

I'm sorry, but you are going to have to be much more specific than this for
us to be able to assist. In what context do you "have the segment" of time;
how is it represented; how is it stored in your table(s), and what do you
want to change all those answers to in order to do something with the more
granular numbers of minutes?

Larry Linson
Microsoft Access MVP