Sorry to come back to you yet again with a newbie question. I have really tried hard with this one to find the answer myself from the Help etc., but I keep hitting a brick wall.
I have a database exported from Bento which includes a field for elapsed time (the “Running time” of videos & movies). Although in Bento this appears as, e.g., “1h 51m”, it has come across into Panorama as an integer (6660, = number of seconds).
I found the Help entry for the timepattern( function, and tried to enter that on the Procedure tab of my “RunningTime” field (which I had set up in formula mode). I started the procedure with RunningTime =, then tried various options for the rest, e.g.,
timepattern(“hh:mm:ss”) and even
timepattern(now(),“hh:mm:ss”) (which I cloned from the Date formula some of you helped me set up).
None of these worked.
I also changed the RunningTime field from Text to Number (Integer). But whatever I did, all that appeared was the plain number “6660”.
Can someone tell me where I’m going wrong here? And also, if possible, where I could have found that information?
Many thanks for your help!