cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
Onjai
Level III

Column formula to round timestamp to nearest minute

Hi,

Looking for a column formula to round timestamp to nearest minute. 

27/06/2017 12:21:13 PM  need to round to 27/06/2017 12:21:00 PM.

Any suggestions?

Cheers.

2 ACCEPTED SOLUTIONS

Accepted Solutions
julian
Community Manager Community Manager

Re: Column formula to round timestamp to nearest minute

Hi @Onjai,

I'm sure there are other ways to approach this, but I've had luck with the following when I've needed to do that (this requires that you have a numeric :DateTime column):

 

Round(:DateTime / 60) * 60

(Edited: replaced with the simpler formula pointed out by Jerry)

 

Hope this helps!

@julian

 

 

View solution in original post

Onjai
Level III

Re: Column formula to round timestamp to nearest minute

I am using the latest version of JMP.  The transform worked as well.

Thank you!

View solution in original post

5 REPLIES 5
julian
Community Manager Community Manager

Re: Column formula to round timestamp to nearest minute

Hi @Onjai,

I'm sure there are other ways to approach this, but I've had luck with the following when I've needed to do that (this requires that you have a numeric :DateTime column):

 

Round(:DateTime / 60) * 60

(Edited: replaced with the simpler formula pointed out by Jerry)

 

Hope this helps!

@julian

 

 

Onjai
Level III

Re: Column formula to round timestamp to nearest minute

Julian,

This worked just fine.

Thank you.

 

jerry_cooper
Staff (Retired)

Re: Column formula to round timestamp to nearest minute

Hi Onjai,
If you're using version 14, you can right-click the heading of your Timestamp column, select New Formula Column->Transform->Round. You'll then get a dialog box to set the desired parameters (because you're wanting to round to the nearest minute, you'll just need to select "Nearest" from the dropdown and click OK). This is the resulting formula:
Round(:Timestamp / 60) * 60
Onjai
Level III

Re: Column formula to round timestamp to nearest minute

I am using the latest version of JMP.  The transform worked as well.

Thank you!

Re: Column formula to round timestamp to nearest minute

:Time Stamp - Modulo( :Time Stamp, 60 );