Automatically round 15 minutes to a time tracker

Platform discussions
, ,
1

Hi,

I need to round a time tracker to the next 15 minutes upper.
Exemple :
0H8m => 0H15 min
0H28m => 0H30min
0H47 => 1H00
1H03 => 1H15

I thought i was close with this formula but I have issue when the hours change by doing the round :

ROUND({TIME#Hours},0)& "h " & (MOD(ROUND({TIME#Seconds}/900,0),4)*15) & “m”

Can someone help ?

2

Reply to my post and based on search in the community :

Round time in decimal :
ROUND(({Time#Hours}-{Time#Hours})*4,0)/4