:format as hours only 1 decimal

[klaas.vanhoeck]

I want to calculate the time between two dates. I tried end-start:formated as hours, but this only gives 1 decimal.
For example: 18:00 till 18:45 gives 0.8

I fixed it with using :formated as minutes /60 but this is laggy sometimes. Does someone know a stable way to do this

thanks!

[eli]

Depends what you are trying to display but this post explains how to find the duration between dates.

Date addition (Specific purpose)

@melon, you can use math.js to do this and I think there are other plugins that do similar things. But it’s very simple to do with standard Bubble features as well. [image] The first thing you have to do is convert the dates to a number we can run math operations on so we can subtract the current date from the payment date. To do this we will use the :extract operator on the end of the date value. [image] [image] In the options here, we could extract the …