I am also searching for this solution. Is this actually a bug? Or is there a way to format the formula to return the difference between the two times in hours and minutes? Or fractions of hours expressed as a two decimal place number? I would like to be able to total the sum of hours and minutes worked in the summary bar as well.
I have searched around a lot, but haven’t found any resources specifying how to get this result with the datetime_diff formula.
I have 2 date fields: “start” and “stop”. Both in European timezone and 24h time format (“same time zone for all…”). 3th field is a formula field to calculate the difference in hours between start and stop (to register hours for labour workers): “DATETIME_DIFF(Einde,Start,‘HH:mm’)/3600000” (format: “decimal”; 1.00 precision).
Question: if I don’t add the “/360000” it doesn’t return eg 2.5h, but only the full hours (2h or 3h). Why? What am I missing here? Why do we have to use this workaround and how can it be 360000 for 2,5h?