I have 2 fields that I am trying to do calculations with.
The one field has a format of time ([h]:mm) and the other is number (value
represents kilograms).
I am trying to do a calculation where the kg/hour needs to be calculated.
But my answer always comes out wrong.
It seems as though the time format saves the numerical value differently.
Example:
Time begin - 08:00
Time ended - 12:00
I did a calc for the difference and got 4:00 which is fine.
This difference is now multiplied by the amount of people that worked that
shift i.e. 4.
I then get the answer 16, which is also fine.
Now I need to calc the kilograms per hour.
Say for instance the kg is 300kg, the calc should get an answer of 18.75.
However I get the answer as 450 which is obviously way out.
when I convert the 16 hours worked in total to number format, instead of
giving me 16, I get 0.67.
What must I do to overcome this?

On Thu, 16 Jul 2009 02:28:04 -0700, bytjie06
wrote:

I have 2 fields that I am trying to do calculations with.
The one field has a format of time ([h]:mm) and the other is number (value
represents kilograms).
I am trying to do a calculation where the kg/hour needs to be calculated.
But my answer always comes out wrong.
It seems as though the time format saves the numerical value differently.
Example:
Time begin - 08:00
Time ended - 12:00
I did a calc for the difference and got 4:00 which is fine.
This difference is now multiplied by the amount of people that worked that
shift i.e. 4.
I then get the answer 16, which is also fine.
Now I need to calc the kilograms per hour.
Say for instance the kg is 300kg, the calc should get an answer of 18.75.
However I get the answer as 450 which is obviously way out.
when I convert the 16 hours worked in total to number format, instead of
giving me 16, I get 0.67.
What must I do to overcome this?

Divide by 24 (which is the number of hours per day).

Hope this helps / Lars-Åke

=Kilogram/(hours*24)

If this post helps click Yes
---------------
Jacob Skaria


"bytjie06" wrote:

I have 2 fields that I am trying to do calculations with.
The one field has a format of time ([h]:mm) and the other is number (value
represents kilograms).
I am trying to do a calculation where the kg/hour needs to be calculated.
But my answer always comes out wrong.
It seems as though the time format saves the numerical value differently.
Example:
Time begin - 08:00
Time ended - 12:00
I did a calc for the difference and got 4:00 which is fine.
This difference is now multiplied by the amount of people that worked that
shift i.e. 4.
I then get the answer 16, which is also fine.
Now I need to calc the kilograms per hour.
Say for instance the kg is 300kg, the calc should get an answer of 18.75.
However I get the answer as 450 which is obviously way out.
when I convert the 16 hours worked in total to number format, instead of
giving me 16, I get 0.67.
What must I do to overcome this?

Thanx
Problem fixed in no time

"Jacob Skaria" wrote:

=Kilogram/(hours*24)

If this post helps click Yes
---------------
Jacob Skaria


"bytjie06" wrote:

I have 2 fields that I am trying to do calculations with.
The one field has a format of time ([h]:mm) and the other is number (value
represents kilograms).
I am trying to do a calculation where the kg/hour needs to be calculated.
But my answer always comes out wrong.
It seems as though the time format saves the numerical value differently.
Example:
Time begin - 08:00
Time ended - 12:00
I did a calc for the difference and got 4:00 which is fine.
This difference is now multiplied by the amount of people that worked that
shift i.e. 4.
I then get the answer 16, which is also fine.
Now I need to calc the kilograms per hour.
Say for instance the kg is 300kg, the calc should get an answer of 18.75.
However I get the answer as 450 which is obviously way out.
when I convert the 16 hours worked in total to number format, instead of
giving me 16, I get 0.67.
What must I do to overcome this?