Help needed - time formula

[soph12081]

Hello

Hopefully someone can help.. I have a formula that divides a number by time.. so how example 12T divided by 2 hours should return 6 tonnes per hour.

In order to do this, the formula needs to be divided by 24. can anybody explain why this is?

Thanks

 

[Tetra201]

Because in Excel time is measured in fractions of 1 day; 1 day = 24 hours.

 

[soph12081]

Thank you for that - I thought it was as simple as this but I wasn't sure.

if my working day only consists of 21 hours, would it be sufficient to divide by 21? or is the dividing by 24 an excel way of working with time?

thank you

 

[Tetra201]

You should use 24 -- it's the Excel way of working with time.
When you enter, say, 6:00, Excel records it as 0.25; 8:00 as 0.333...; 18:00 as 0.75 and so on.