Sum of HH:NN

[Moxioron]

Hello.

I have a with the following expression:
Expr1:Format(([SumOfTime]/86400),"hh:nn")

Works great to convert the seconds to hours and minutes.

However, I can't use the expression in any other expression. I am trying to get productivity from:
Expr3: [SumOfVolume]/[Expr7]

Instead of course I get #Error for that column.

If I take the format out of Expr 1 and just use [SumOfTime]/3600 and of course it works awesome. However, I don't want 45 minutes to reflect .75, so that will not work.

Where I am going wrong? Thank you.

 

[boblarson]

You can't use an expression you have created in the same query as an alias in another expression. I think you would find that you can create that expression and then you can use it like you want but ONLY if you took this query and then used it in another query and then used [SumOfVolume]/[Expr7].

To use it in the same query, you need to just use the entire calculation.

Also - make your aliases meaningful instead of Expr7. It will be better later on down the line when you, or someone who is having to follow you, needs to know what it is.