Forum Discussion

New_be's avatar
New_be
Icon for Helper V rankHelper V
6 years ago
Solved

Time Function: Round Up to Nearest 15 minutes

Hi everyone!😊 I have one problem here. I have time in & time out. And for time in i round up to the nearest 15 mins. For the correct example; TimeIn            TimeOut NewTimeIn 1/9/202...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    New_be , I think the best way is to take out the minute

     

    Something like this

    [Date] + #duration(0,0,15- Number.Mod(Time.Minute([Date]),15),0)

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

New_be , I think the best way is to take out the minute

 

Something like this

[Date] + #duration(0,0,15- Number.Mod(Time.Minute([Date]),15),0)

  • New_be's avatar
    New_be
    Icon for Helper V rankHelper V
    6 years ago

    amitchandak  so, is it correct from my understanding, time in is;


    #duration(0,0,15 - Number.Mod(Time.Minute([InTime]),15)
    at 11.46 PM, then 46 mod 15 will be 1. And then 15 mins - 1 = 14mins

     

    [InTime] + #duration(0,0,15 - Number.Mod(Time.Minute([InTime]),15),0)

    11.46 PM + 14 mins = 12:00 AM

     

    So this way is same with roundUp to the nearest 15 mins or..? Can u please explain? Cause this is a very very good input for me ğŸ˜€