calculating tonnes

[James__S]

Hi

I am using a table and need help calculating a tonnage

=([@[Time OUT]]-[@[Time IN]])/[@[Tonnes Processed]]

Time IN = 12:00:00 AM
Time OUT = 12:20:00 AM
Tonnage = 24

Processing time = 20 minutes therefore the answer needs to be 72 tonnes per hour

I rarely use tables but how do i get the answer for 72 instead of 0.000578222

Thank you

 

[wideboydixon]

=[@[Tonnes Processed]]/(([@[Time OUT]]-[@[Time IN]])*24)

Perhaps?

WBD

 

[James__S]

Thanks for the solution

1 question when i use Evaluate the Formula for better understanding how does 12:20:00 AM = 0.0138888888888889

Thanks

 

[wideboydixon]

Times are stored as fractions of a day. For example, 12:00 midday = 0.5, 06:00 = 0.25, 18:00 = 0.75 etc.

12:20:00 AM = only 20 minutes into the day so is stored as (20 / 60) / 24 = 0.01388888888..

WBD

 

[James__S]

Thank you