AnsweredAssumed Answered

How to round time minutes to nearest 10 units.

Question asked by muhammad.ikram@contedia.com on Jun 14, 2018
Latest reply on Jun 14, 2018 by muhammad.ikram@contedia.com

Hello Community.

 

I have a time field which stores times for example like this.

 

1:19

1:45

 

What I want to do is round the 'minutes' to the next nearest units.

 

For example;

 

0.1 = 6

0.2 = 12

0.3 = 18

0.4 = 24

 

If the time is 1:19 -> It should become 1:24 (because 19 is more than 18(see above)).

and if the time is 1:14 -> It should become 1:18 because 14 is more than 12. see above.

 

I created an calculation field in my database; I have set up variables.

 

How I can round the time field.

 

I was thinking to set up units variables; than have if statement; if the time is 1:19; change it to 1:24

 

How I can have those if statements which would round the minutes units of time.

 

 

Many Thanks.

Outcomes