Compute duration time in date/time format?

[Alberto Gz]

I'm building a database for time tracking, and need create a chart to add diff between start time and stop time.

My problem is result for field 'duration' is a string then can't compute it. I could have a extra field (hidden) for duration in milliseconds to compute duration along the days, but I want chart it showing as HH:mm minutes.

How I can build this?

Thanks

[Bill Crews]

My problem is result for field 'duration' is a string then can't compute it. I could have a extra field (hidden) for duration in milliseconds to compute duration along the days, but I want chart it showing as HH:mm minutes.

Haven't done much charting, but if you have the milliseconds in a field, you can create a JavaScript field for display.

Assuming you have milliseconds in an Integer field called Duration, and for sharing, you need a string field Duration Display in HH:mm format.

Create the JavaScript field. Press Add JavaScript libraries. Check the box for moment.min.js. Use script...

moment(field("Duration")).format("HH:mm")

See http://momentjs.com/docs/#/durations/ and http://momentjs.com/docs/#/displaying/

[Alberto Gz]

Thank you for your reply Bill.

I can have one field in milliseconds as integer and other field in date/time format as string.

Problem is that I want compute its values in a Memento chart. If I choose compute field in integer data, computing is right, but units are in miliseconds on my chart. So is not easy redeable.

If I choose time field, data is string and can't computable.

In spreadsheets usually data can be integer or float but it can be display as string. Example cells formated as currency or date.

[Bill Crews]

I bet the answer is within the charting facility in Memento, then. I wish I knew more about it.

[Alberto Gz]

Here a screenshot of chart edit options. Sorry for my app us in spanish language.

When in values (valores) is selected a field that isn't numeric, function (función) is only number of entries for compute. That is logic, so strings can't be computed.

I don't see how I can to do that compute time values but show it in format like HH:mm in chart.

[Bill Crews]

I have no idea, but hopefully someone else does.

[Alberto Gz]

Thank you anyway!

[Alberto Gz]

https://imgur.com/a/ubGzV