Time Calc output in Hours:Min

58 views
Skip to first unread message

Michael Carter

unread,
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

unread,
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})

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