Rounding to the nearest minut

[Anonymous]

I'm looking to round time to the nearest minut and is using the following formula but when converted to time the time is off.

CloseTime = mround('5100'[Close Time], time( PM1,1,0)

I presume it is something wroing with the 1,0

Data

Close Time

10:11:25 PM   where I want it to show 10:12:00 PM

[Tanushree_Kapse]

Hi @Anonymous ,

Create a new column
CloseTime = CEILING('5100'[Close Time],"0:01")

Mark it as a solution if it answers your question. Kudos are always appreciated.

Thanks

[serpiva64 · Accepted solution]

Hi,

try this

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !