Hi there,
I've got a column of integer data representing seconds, that I'd like to be able to display as a time interval (HH:mm:ss) in an Impromptu report.
Ie, get a number like 506 and display it as 00:08:26
and do this for a whole column of data.
Has anyone come up with a solution for this one using Impromptu?
There doesn't appear to be a function to convert from integer to interval, or any way to manipulate a number representing seconds into a time.