Simple formula, but not simple to me.
Hi all - first off, obviously I'm not a coder hence the request. I have a field called 'Episodes x Duration' and in there it holds TV production data of how many episodes by how many minutes per ep...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIt is unclear from your question what the source data looks like.
If indeed it looks like
10x60
The the formula to extract the [Episodes] would be a formula numeric field
ToNumber(Left([Episodes x Duration]))
and the formula for the formula numeric field type [Duration] would be
ToNumber(Right([Episodes x Duration]))
The formula for [Total Minutes] would be a formula numeric field type
[Episodes] * [Duration]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
If indeed it looks like
10x60
The the formula to extract the [Episodes] would be a formula numeric field
ToNumber(Left([Episodes x Duration]))
and the formula for the formula numeric field type [Duration] would be
ToNumber(Right([Episodes x Duration]))
The formula for [Total Minutes] would be a formula numeric field type
[Episodes] * [Duration]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
