cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
chandankishor66
chandankishor66
Level III

Subtracting number of hours from Date and time

Created: Sep 10, 2022 12:10 AM  |  Last Modified: Jun 9, 2023 8:58 AM (958 views)

HI,

 

I want to subtract 6 hrs in 05-07-2022 01:00  so final value should be  04-07-2022 19:00
Can you please suggest me how perform this calculation in JMP16.

 

Many thanks

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User txnelson
Super User
Solution

Re: Subtracting number of hours from Date and time

Sep 10, 2022 01:00 AM (954 views)  |  Posted in reply to message from chandankishor66 09-10-2022

Use the In Hours() function

Date = Informat( "05/07/2022 01:00:00", "m/d/y h:m:s" );
New Date = Date - In Hours( 6 );
Show( Format( New Date, "m/d/y h:m:s" ) );

Displays

Format(New Date, "m/d/y h:m:s") = "05/06/2022 7:00:00 PM";
Jim

View solution in original post

1 REPLY 1
txnelson
Super User txnelson
Super User
Solution

Re: Subtracting number of hours from Date and time

Sep 10, 2022 01:00 AM (955 views)  |  Posted in reply to message from chandankishor66 09-10-2022

Use the In Hours() function

Date = Informat( "05/07/2022 01:00:00", "m/d/y h:m:s" );
New Date = Date - In Hours( 6 );
Show( Format( New Date, "m/d/y h:m:s" ) );

Displays

Format(New Date, "m/d/y h:m:s") = "05/06/2022 7:00:00 PM";
Jim