Time calculation in Minutes

roman.jeckelmann1 · 2024-10-08T17:28:14.724Z

I would like to calculate the time between a start and an end datetime (formatted in Minutes) minus a the breaktime inbetween (counted as Minutes). Sometimes but not everytime a get the result of 1 Minute less than the correct result.

E.g. Start datetime 01.01.2024 07:30 am // End datetime 01.01.2024 4:30 pm // Break of 60 Minutes. The correct result would be 480 Minutes resp. 8 hours. But I get the result in the database with 479 Minutes.

Do you have any idea why this happens (sometimes)?

data1768×307 29.6 KB

Many thanks for your support.

adamhholmes · 2024-10-08T17:38:26.518Z

Are all your times exactly rounded to a minute?

roman.jeckelmann1 · 2024-10-08T17:49:24.931Z

I just added two pictures. And I used the datetime picker

image978×186 8 KB

The weird thing is that the most of the times, it works. But sometimes it doesn’t.

system · 2024-12-17T17:28:21.430Z

This topic was automatically closed after 70 days. New replies are no longer allowed.