Skip to main content

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
 

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)

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

Reply


Terms & Conditions