Groups keyboard shortcuts have been updated
Dismiss
See shortcuts
Skip to first unread message
Michael Carter
May 19, 2019, 12:23:00 AM5/19/19
to mementodatabase
New to Memento. I have three fields DepartTime, ArriveTime and TravelTime. Travel time is a calculated field #{arrive time}-#{depart time}/3600
I want to format the output to HH:MM How do I do this please?
Mike
Michael Carter
May 19, 2019, 6:42:42 PM5/19/19
to mementodatabase
I tried this. DepartTime = 11:00 AM and ArriveTime = 02:20 PM
Changed TravelTime calculated field to: formatDuration(#{arrive time}-#{depart time})
Changed TravelTime calculated field to: formatDuration(#{arrive time}-#{depart time})
It now returns: For Input String: "03:20:00"
The time format is how I want it, but how do I get rid of the string "For Input String" preceeding the time??????
Mike
Reply all
Reply to author
Forward
0 new messages