Ah, very interesting idea! Not at the moment I’m afraid, but I can see how that would be a really useful addition when building your recipes. Certainly we could look at potentially adding a “Demo brew sheet” mode that allowed you to see the affect your changes would have live.
Although if the issues are specifically around “How will this calculation field work?” a nice solution as well could be the ability to go to the calculation field and see the inputs that it takes as a form, so that you can put some example data in and see what it produces. This would be the quicker of the two to launch, but it might be it doesn’t quite do what you need. Either way let us know!
Now, using times in a formula! Breww basically turns the time that has been recorded, let’s say 13:00, into a Unix timestamp. Without wanting to get too technical, a Unix timestamp is the number of seconds since Thursday, 1 January 1970 (I won’t explain why here ), but the key is that this time is now a number that can be used in the formula. On its own its pretty pointless, but if you subtracted two times on your brew sheet from each other, for example
Mash end -
Mash start you would get the difference between the two in minutes (we turn it into minutes, because seconds would probably not be useful information). But if you were just to multiply a time measurement by 2 for example, you would end up with a pretty meaningless number - but then again I have no idea what would be a useful result of 5pm x 2…
Given that it is a count of seconds, you will want to write
Mash end -
Mash start (as an example), as
Mash end will be the bigger number of the two, so that will get you your mash duration as a positive number.
I hope that explains it, but let me know if not!