Time Calc output in Hours:Min

瀏覽次數:80 次
跳到第一則未讀訊息

Michael Carter

未讀,
2019年5月19日 凌晨12:23:002019/5/19
收件者: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

未讀,
2019年5月19日 下午6:42:422019/5/19
收件者: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
回覆所有人
回覆作者
轉寄
0 則新訊息