The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
May 08, 2024 01:06 AM
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:
Solved! Go to Solution.
May 08, 2024 03:36 AM
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)
May 08, 2024 03:36 AM
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)
May 08, 2024 07:30 AM
thanks a lot, that did the trick