krmullins Posted September 22, 2006 Share Posted September 22, 2006 I need to do a couple of things related to time but my math skills are not getting the job done. Any help would be appreciated. I have a perfect time (pt) and an actual time (at) I need to find the difference between those two in non negative numbers, and then have text that will tell me if the difference is late or early. example 1 pt = 13:14:25 at = 13:14:26 desired result Field 1 = at - pt = 1 Field 2 = at - pt = late example 2 pt = 13:14:25 at = 13:13:24 desired result field 1 = at - pt = 61 field 2 = at - pt = early example 3 input pt = 13:14:25 at = 13:14:25 desired result field 1 = at - pt = 0 field 2 = at - pt = zero Field 1 represents the difference between pt & at in seconds and needs to be positive so I can do a sum to get the total difference in time over multiple checkpoints. Thanks Kevin timing.zip Link to comment Share on other sites More sharing options...
comment Posted September 22, 2006 Share Posted September 22, 2006 Field 1 (result is Number ) = Abs ( pt - at ) Field 2 (result is Text ) = Choose ( 1 + Sign ( pt - at ) ; "Late" ; "Zero" ; "Early") Link to comment Share on other sites More sharing options...
krmullins Posted September 22, 2006 Author Share Posted September 22, 2006 Thanks comment that is perfect. I figured there had to be something that would give an absolute number, I just couldn't think of how I could state it. The sign I never would have got. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6553 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now