# Duration between hours on different days
**URL:** https://community.thunkable.com/t/duration-between-hours-on-different-days/1662003
**Category:** Questions about Thunkable X
**Created:** [December 28, 2021, 11:42pm UTC](https://community.thunkable.com/t/duration-between-hours-on-different-days/1662003 "2021-12-28T23:42:01Z")
**Posts on this page:** 16
**Page:** 1
### Author:  [@stronazyskuup](https://community.thunkable.com/u/stronazyskuup)
#### Post date: [December 28, 2021, 11:42pm UTC](https://community.thunkable.com/t/duration-between-hours-on-different-days/1662003/1 "2021-12-28T23:42:02Z")
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.
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [December 29, 2021, 11:02pm UTC](https://community.thunkable.com/t/duration-between-hours-on-different-days/1662003/2 "2021-12-29T23:02:06Z")
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:
```auto
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:
[https://x.thunkable.com/copy/cb9d53a5dee666da14d5f0a1a334f19d](https://x.thunkable.com/copy/cb9d53a5dee666da14d5f0a1a334f19d)
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.
---
### Author:  [@stronazyskuup](https://community.thunkable.com/u/stronazyskuup)
#### Post date: [December 30, 2021, 10:10am UTC](https://community.thunkable.com/t/duration-between-hours-on-different-days/1662003/3 "2021-12-30T10:10:56Z")
Okay. How to make one date and time? how to combine it? is “serial date” the only way?
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [December 30, 2021, 11:12am UTC](https://community.thunkable.com/t/duration-between-hours-on-different-days/1662003/4 "2021-12-30T11:12:14Z")
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.
---
### Author:  [@stronazyskuup](https://community.thunkable.com/u/stronazyskuup)
#### Post date: [December 30, 2021, 11:55am UTC](https://community.thunkable.com/t/duration-between-hours-on-different-days/1662003/5 "2021-12-30T11:55:02Z")
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?
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [December 30, 2021, 12:00pm UTC](https://community.thunkable.com/t/duration-between-hours-on-different-days/1662003/6 "2021-12-30T12:00:05Z")
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
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [December 30, 2021, 12:00pm UTC](https://community.thunkable.com/t/duration-between-hours-on-different-days/1662003/7 "2021-12-30T12:00:35Z")
You can use a `web viewer` and get the duration using JavaScript code.
You can also build a Google Apps Script code and deploy it so you can use it as `web API`.
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).
> [@Date operations (No API)](https://community.thunkable.com/t/date-operations-no-api/1355407):
>
> Hi everyone It´s been a while since my last post in the community I have a couple of questions regarding operations with dates (I didn´t find a solution on the community thad doesn´t use API´s) I need to pick a date and do some maths with it and then show the results in other labels Example: I selected 2021-10-21 Then: Label 1: 2021-10-21 + 5= 2021-10-26 Label 2: 2021-10-26 (result of the previous operation) + 10= 2021-11-05 Of course ther is two “problems”. Wich blocks I need to use? Ho…
---
### Author:  [@stronazyskuup](https://community.thunkable.com/u/stronazyskuup)
#### Post date: [December 30, 2021, 2:22pm UTC](https://community.thunkable.com/t/duration-between-hours-on-different-days/1662003/8 "2021-12-30T14:22:46Z")
i did something like this and it works for one day difference and i don’t need more.
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [December 30, 2021, 5:20pm UTC](https://community.thunkable.com/t/duration-between-hours-on-different-days/1662003/9 "2021-12-30T17:20:47Z")
How would you handle th e difference between 12/31/2021 11:30am to 1/1/2022 12:30pm.?
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [December 30, 2021, 6:45pm UTC](https://community.thunkable.com/t/duration-between-hours-on-different-days/1662003/10 "2021-12-30T18:45:00Z")
Using JavaScript in a `Web Viewer`, you will do this
```auto
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.
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [December 30, 2021, 7:21pm UTC](https://community.thunkable.com/t/duration-between-hours-on-different-days/1662003/11 "2021-12-30T19:21:59Z")
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.
---
### Author:  [@stronazyskuup](https://community.thunkable.com/u/stronazyskuup)
#### Post date: [December 31, 2021, 10:47am UTC](https://community.thunkable.com/t/duration-between-hours-on-different-days/1662003/12 "2021-12-31T10:47:19Z")
yes, I emphasized the fact that it works up to one day 🙂
---
### Author:  [@stronazyskuup](https://community.thunkable.com/u/stronazyskuup)
#### Post date: [December 31, 2021, 10:49am UTC](https://community.thunkable.com/t/duration-between-hours-on-different-days/1662003/13 "2021-12-31T10:49:22Z")
when I find free time I will check this method. I can see that it is better.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [December 31, 2021, 1:01pm UTC](https://community.thunkable.com/t/duration-between-hours-on-different-days/1662003/14 "2021-12-31T13:01:19Z")
See this from my side
[https://x.thunkable.com/projectPage/61cee4c82390290010915968](https://x.thunkable.com/projectPage/61cee4c82390290010915968)
This project will send your input to a JavaScript code in a `Web Viewer` and will get back the number of seconds between the two dates.
The rest is done in the project.
This is the JavaScript Code
```auto
```
You can of course enhance on it but this should give you a good start.
CC:
@manyone
@jared
@tatiang
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [December 31, 2021, 3:14pm UTC](https://community.thunkable.com/t/duration-between-hours-on-different-days/1662003/15 "2021-12-31T15:14:36Z")
> [@muneer](#):
>
> See this from my side
> [Thunkable](https://x.thunkable.com/projectPage/61cee4c82390290010915968)
Nice share!
---
### Author:  [@system](https://community.thunkable.com/u/system)
#### Post date: [March 31, 2022, 3:14pm UTC](https://community.thunkable.com/t/duration-between-hours-on-different-days/1662003/16 "2022-03-31T15:14:51Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.