Help

Roundup results in #ERROR

Topic Labels: Formulas
Solved
Jump to Solution
122 2
cancel
Showing results for 
Search instead for 
Did you mean: 
f0rd42
4 - Data Explorer
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
Alexey_Gusev
12 - Earth
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)

See Solution in Thread

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

thanks a lot, that did the trick