Multiply Time Values

[evosingh]

Hi All

Newbie here!!

Been a while since i used Access 2003 and did any calculations in queries. Just a quick query - im trying to calculate the total time a manufacturing operation will take based on the quantity involved and the operation time itself.
I tried simply doing the calculation as Time x Quantity, but the result are not what i expected.
What i'd like displayed for example is:
Operation Time is 00:01:30 (hh:mm:ss)
Quantity is 78
So total time is 117 minutes = 01:57:00 (this is how i'd like it displayed

Im going to be using this information for a production planning system im working on

Any help would be appreciated

EvoSingh

 

[wilpeter]

In the Query properties of the calculated field, set the format to hh:nn:ss

 

[Galaxiom]

You could run into problems if the product of the time and the quantity results in more than 24 hours. The hh:mm:ss format will only display the hours minutes and seconds regardless of the number of days that could also be included in the result of the calculation.

Consider using this expression for display, remembering that the result is a string:

 Int({date expression})*24 + Format({date expression},"h") & ":" & Format({date expression},"nn:ss")

I would save it as a function.