Time calculation in Minutes

Need help
1

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)?

data
data1768×307 29.6 KB

image

Many thanks for your support.

2

Are all your times exactly rounded to a minute?

3

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

image
image978×186 8 KB

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

4

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