When I use HOURS_DIFF function it return a wrong value
HOURS_DIFF for 9h00,11h30 return 2 instead of 2.5
What’s your syntax?
HOURS_DIFF("23:00","21:30")
returns 01:30 in my board…
What I need is to calculate duration. When I try to convert 1h30 to a number either 1.5 h or 90 min it returns a wrong number. The main purpose is to be able to graph the duration.
You’re not explaining which types of fields are involved, not publishing the syntax that doesn’t work for you, not giving a concrete example with values involved… Difficult to help you out…