Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 30, 2024 04:19 AM
Hi, 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
Solved! Go to Solution.
Sep 30, 2024 05:29 AM
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
Sep 30, 2024 05:29 AM
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
Oct 01, 2024 03:46 AM
This is great. Thank you very much