Roundup results in #ERROR

[f0rd42]

Hi.

I have two Date files with Time Called Start and End

e.g.:

Start=08.05.2024 09:54

End= 08.05.2024 12:00

in another filed I'd like to calculate this into hours rounded to full 15 minutes using:

IF( AND({End}, {Start}),

ROUND(DATETIME_DIFF({End}, {Start}, 'm') / 15) / 4

)

the result of this is 2 which is correct as I used "ROUND"

But I'd actually like to ROUNDUP, so the result should be 2.25

But when I change ROUND to ROUNDUP in the above formula, I just get #ERROR back

Further down the road I'l like to convert the this into "working days" of 8 hours each

So let's say I have two entries with 2 hours and 8 hours, that would sum up into 1,25 "working days"

reason for this: I'm building a tracker of PS engagements. Customer purchases a fixed amount of days and engineers enter information about what work has been done. There can be multiple Tracker entries for a PS Project and I need to sum this up into "Working days" of 8 hours each

any help here is highly appreciated

thanks

[Alexey_Gusev · Accepted solution]

Hi,
ROUND and ROUNDUP functions are used with 2 parameters, (value, precision)
In ROUND you can omit 2nd parameter (default is 0), while in ROUNDUP - cannot 🙂
So, 

IF(AND({End}, {Start}),  ROUNDUP(
    DATETIME_DIFF({End}, {Start}, 'minutes')/15,0
)/4)

[f0rd42]

thanks a lot, that did the trick