Problem calculating hours

35 views

Skip to first unread message

unread,

Nov 13, 2019, 11:37:53 AM11/13/19

to mementodatabase

Hello.

I have 2 time fields (Begin and End) and a calculation field (Total) with the calculation of the of hours between Begin and End time.

That works just fine.

However, when i put for example 14:00 as start time and 00:00 as end time (midnight) the result is 00:00.

When i use 23:59 as end time the calculation is correct. Is there a way to solve this problem?

Second question:

What would be the right format for an aggregation to calculate the sum of the hours in the Total field?