Converting an integer to hours in a query

[gmoss]

I am trying to calculate the amount of time left for an operation and convert
it to hours. (Qty remaining/machine speed per hour) - this gives me the
number of hours remaining as an integer
I would like to estimate the time of day that the job is expected to be
completed using 8:00 am as the start time for the schedule.

Any ideas would be appreciated

 

[Ken Snell MVP]

You could use a calculated field with this expression:

EndingTime: #8 AM# + [Qty remaining] / [Machine Speed per hour] / 24

 

[gmoss]

Thanks it worked well

You could use a calculated field with this expression:

EndingTime: #8 AM# + [Qty remaining] / [Machine Speed per hour] / 24

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

I am trying to calculate the amount of time left for an operation and
convert
it to hours. (Qty remaining/machine speed per hour) - this gives me the
number of hours remaining as an integer
I would like to estimate the time of day that the job is expected to be
completed using 8:00 am as the start time for the schedule.

Any ideas would be appreciated

 

[Ken Snell MVP]

Additionally, the DateAdd function could be used (as suggested by MGFoster):

EndingTime: DateAdd("h", [Qty remaining] / [Machine Speed per hour] / 24, #8
AM#)
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

Thanks it worked well

You could use a calculated field with this expression:

EndingTime: #8 AM# + [Qty remaining] / [Machine Speed per hour] / 24

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

I am trying to calculate the amount of time left for an operation and
convert
it to hours. (Qty remaining/machine speed per hour) - this gives me the
number of hours remaining as an integer
I would like to estimate the time of day that the job is expected to be
completed using 8:00 am as the start time for the schedule.

Any ideas would be appreciated