Jump to content

Finding the diffrence in time


This topic is 6449 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

This topic is 6449 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.