Hello!
I am trying to create a MashApp from an Excel table, where there are two coloums containing the starting time of a given process (2010-01-16 16:55:01), and the end time of a process (2010-01-18 13:32:19). And I would like to display the time difference between these two timestamps (which would be 1 day 20:37:18). Is there any way to do this with MashZone?
Thank you,
Zsolt
Thomas Staub on
Hi Zsold
There is a way to do that. If you convert a date-object to datatype number you will get the time from 01.01.1970 to the date in milliseconds.
If you have two date-objects, you can do that for each and build the difference. The Result is the difference im milliseconds. Than you need a factor for the desired format (f.e. 3600000 for the difference in hours).
Here is a small example:
Regards
Thomas