Hello I have three fields hours1, hours2 and total hours.
Total hours is calculated fields based on the sum of hours1 and hours2.
I use the formula
It works if sum of the 2 fields are whole numbers. for example. for (18:00 - 16:00) result is 2. But if there are minutes in time i.e. (18:30 -16:00) result will be 2.12, and I am looking for the 2.5 result.
Can anyone help?