Jump to content

Time calculations


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

Recommended Posts

Sirs, how would I do a calculation for the time difference between two entered fields, such as Start Time, End Time? I have tried to make such a calculation, by making the start and end time values TIME, but the result makes no sense. It thinks the time value, for the 24 hour clock, is minutes. It will not display the time normally, but puts the : mark after the minutes and then adds seconds, thus 1630 is displayed as 1630:00, which must have something to do with the calculation. I cannot enter the times as numbers since the calc will be totally wrong. I do not want to use the 12 hour clock, but will if this is the only way to do it. And if the two times are on different days (start time 2200 day one, end time 0300 day two for example) how would the program know that?

Thanks in advance, Glen

Link to comment
Share on other sites

And if the two times are on different days (start time 2200 day one, end time 0300 day two for example) how would the program know that?

Hi

you have to use two TimeStamp fields as TimeStart and TimeEnd

TimeEnd - TimeStart, result as Time will give you the exact time elapsed in this format:

hh:mm:ss

Link to comment
Share on other sites

Using Timestamps for entry is better, but not mandatory. Try:

EndTime - StartTime + ( EndTime < StartTime ) * 86400

The result should be set to Time. This assumes that the elapsed time is less than 24 hours in total, so when starting time is later than ending time it adds 24 hours to the end.

Link to comment
Share on other sites

This topic is 5716 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
 Share

×
×
  • Create New...

Important Information

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