Before the duration field was added, I was using “Start” and “Stop” fields with this formula:
IF( AND(NOT({Start}), NOT({Stop})), "", IF( {Stop}, ROUND((DATETIME_DIFF(Stop, Start, 'minutes') / 60) * 4 , 0) / 4 , ROUND((DATETIME_DIFF(NOW(), Start, 'minutes') / 60) * 4 , 0) / 4 ))
This gave me a nicely rounded decimal number for billing purposes.
I’d like to use the new duration field to eliminate a step here, but can’t figure out how to convert that fields value.