cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X

Time Difference Calculations

ppal
17-Peridot

Time Difference Calculations

Hi Could someone explain why I am getting different answers  - 58 & 59 min ?

1 ACCEPTED SOLUTION

Accepted Solutions
nas0k
7-Bedrock
(To:ppal)

It seems to be tolerance related.

your calculated delta t using 15 decimal places shows a time less than 59 minutes. Redefining delta t to 3540s works okay.

I hope this helps.

View solution in original post

2 REPLIES 2
nas0k
7-Bedrock
(To:ppal)

It seems to be tolerance related.

your calculated delta t using 15 decimal places shows a time less than 59 minutes. Redefining delta t to 3540s works okay.

I hope this helps.

JoshG
1-Newbie
(To:ppal)

It has to with the functions Trunc and trunc.  Trunc takes the first parameter and divides it by the second, then applies the function of trunc which cuts off the decimal part.  The result is then multiplied by the second parameter.

Since your delta t used the value in hours, you have a large decimal part that was completely cut off.

Top Tags