This is how I calculate the duration. it works, but there is a problem when the hours are not on the same day. Is there a way to do this? i found one forum post but the calculations there are in google sheet.
you will need to include the full year month day into your calculation. say you’ve got 2 date time values, date1, hour1, minute1 and date2, hour2, minute2 - and you want to compute the difference (in minutes) between the two. simply convert date1 to serialdate1 (number of days since march 1960), do the same for the 2nd date, then compute the following:
serialtime1 = (serialdate1 * 24 * 60) + (hour1 * 60) + minute1 serialtime2 = (serialdate2 * 24 * 60) + (hour2 * 60) + minute2
now both values are expressed as number of minutes since march 1, 1960. simply subtract the 2 values and you get the correct duration between the two values - in minutes!
how do you convert a date to serial date?
link to my project:
cut-n-paste the block ymd2serial and use it to compute date serial from year,moth, day. then convert the values to minutes and it’s just a matter of subtraction to compute duration.
Okay. How to make one date and time? how to combine it? is “serial date” the only way?
you can use @muneer’s trick: create a google sheet with 5 columns: date1, time1, date2, time2, diff and enter the formula in diff as the difference between the 2 date and times. update the first 4 columns then re-read the whole row and get the value of diff.
in kodular or app inventor it is built-in. Here really is no other way here than linking to google sheets just to calculate the duration?
To get a duration of time between two points of time, your best bet is to use the seconds since 1970 block.
End time - start time / 60 = duration in minutes
You can use a
You can also build a Google Apps Script code and deploy it so you can use it as
Thunkable X is open code in this regards so you can choose many other ways to get the calculations.
See this post which I explained an example of how to get the date after number of days (added or subtracted).
How would you handle th e difference between 12/31/2021 11:30am to 1/1/2022 12:30pm.?
Web Viewer, you will do this
const startDate = '2021-12-31'; const endDate = '2022-01-01'; const diffInMs = new Date(endDate) - new Date(startDate) const diffInDays = diffInMs / (1000 * 60 * 60 * 24); console.log( diffInDays );
This will work for any two dates.
My question was meant for @stronazyskuup -
I just wanted to illustrate that he needs dates in order to do tiime differences properly. However if his app will never encounter durations over 24 hours, his method will do nicely.
yes, I emphasized the fact that it works up to one day
when I find free time I will check this method. I can see that it is better.
See this from my side
Web Viewer and will get back the number of seconds between the two dates.
The rest is done in the project.
You can of course enhance on it but this should give you a good start.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.