# Roundup results in #ERROR

Topic Labels: Formulas
Solved
122 2
cancel
Showing results for
Did you mean:
4 - Data Explorer

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

1 Solution

Accepted Solutions
12 - Earth

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)``````
2 Replies 2
12 - Earth

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)``````
4 - Data Explorer

thanks a lot, that did the trick