+4Hi, I'm simply trying to subtract hours in one field from hours in another. I have a column with 'hours recorded' and one with 'hours billed'. They are both formatted as time units (hours). I just want to subtract one from the other in a new field. As an additional question is there a way to set the hour units to just hours, with no minutes, at the moment it's h:mm and I need to enter a 0 for minutes each time Thanks
Best answer by Pascal_Gallais-
Hello,
The formula is a simple substraction:
But, you need to format the result:
This being said, the interest of using duration type fields is to let the system deal with minutes when defining such computations. Hence, if you only provide a value for the number of hours and never for the number of minutes, it would be easier to define your fields as number type fields with no decimals, the formula still being a substraction.
Regards,
Pascal
+21Hello,
The formula is a simple substraction:
But, you need to format the result:
This being said, the interest of using duration type fields is to let the system deal with minutes when defining such computations. Hence, if you only provide a value for the number of hours and never for the number of minutes, it would be easier to define your fields as number type fields with no decimals, the formula still being a substraction.
Regards,
Pascal
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.