Calculate with date-time fields

[animax]

hi,

I have two "date-time" fields in the entity. One field is the start time in the format "dd.mm.yyyy hh:mm" and one field is the end time field, also in the format "dd.mm.yyyy hh:mm."
I need the minutes between the end time and the start time in one field.
Example:
Start time 10/14/2025 3:00 PM
End time 10/14/2025 3:15 PM
Result: 15 (minutes)
and after that i would prefer to show the hours, like 0,25 (15 minutes)

I've already looked in the forums, but haven't found anything suitable. The diff function didn't work the way I did it.

How do I get the minutes?

In the german Excel Version, the function is:
=RUNDEN((B7-A7)*24;2)
Example:


Thank you

[lazovic]

Hi animax,

Please use the following formula script example:

$dateA = '2025-07-08 12:30:11';
$dateB = '2025-07-08 12:45:11';

$minDiff = datetime\diff($dateB, $dateA, 'minutes');
$hoursDiff = number\round($minDiff / 60, 2);

output\printLine($hoursDiff);

Output: 0.25

[animax]

Thank you...

I use a floating-point variable to store the result. The variable is called "zeitberechnung"

My start time is called "StartTime," and my end time is called "EndTime."

I tried to adopt it, but it doesn't work; I'm not a professional. Could you rewrite the script for me? Is floating point number for the result correct?

[shalmaxb]

The formula would be:

minuten = datetime\diff(ende, beginn, 'minutes')

You calculate the minutes between start and end, here also in german. 'minutes' is in english, because it makes part of the formula.

[lazovic]

animax,

Please try using this formula script:

$minDiff = datetime\diff(endTime, startTime, 'minutes');
zeitberechnung = number\round($minDiff / 60, 2);

[animax]

Thank you very much! Thats it! Perfect!