On a page I have a reporting screen in FPMI so I am hoping I am posting this in the right section. Anyway the dataset that populates this reporting screen comes from a query. The one section of the query brings in a value related to production time. However this value is in Seconds. I know the math on how to convert this value to Hours, Min, and Sec but am unsure exact how to incorporate this so it can be displayed properly on the reporting screen.
hours = floor(prodtime/3600)
min = floor(floor(prodtime/3600)/60)
sec = prodtime - ((hours * 3600) + (min * 60))
So this can take the data and convert it to the required numbers. But how would i then take this and set it up so that on the report it would show 2hr 27min 15sec?
I can get the report to show the hr min and sec titles but the substitution and conversion area has me a bit confused.
Thanks and have a great day.