Jacob the attached file might work a little better for you.
--Shanw (misspelled my own name)
Richard was right putting in some description so you don't have to open the workbook is handy. (Click the picture to read it.)
So Richard where's the new avatar you promised?
Richard, Very Nice!
Message was edited by: Shawn Wallwork
Displaying Time.twbx.zip 19.2 KB
Exactly what I was looking for. I appreciate the notes which made it easy for me to walk through your calculation.
Thank you for your help Shawn!
Jacob, glad I could help. I also wanted to mention that using the pop-up tooltip on the red X can be helpful, but some times it can lead you off chasing floats & strings & fighting the aggregate/non-aggregate battle, over-complicating everything. Other than letting it help me chase parenthesis and commas I usually take what it says with a grain of salt. Happy coding.
It helped me as well. thanks.