Jump to content

Time calc - Newbie question


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

Recommended Posts

Need some newbie help here..

How do I calculate two time fields?

I have a "start time" and a "stop time".

What I want is to calculate this, so I can get the total hours in a third field named "total time".

And, if these hours are passing midnight?

Confused :)

Link to comment
Share on other sites

If I understand timestamps correct, I have to auto enter a timestamp in "start" and "stop", using a script or something. Then calculate the two timestamp values?

Does it work even if the time is passing midnight?

How do I show the result in hours?

Don't need the date and everything...

Thx.

Link to comment
Share on other sites

To answer a question you've asked twice:

"Does it work even if the time is passing midnight?"

Timestamps are beautiful. Because they include the date, they will perform math properly past midnight, adjust for months, years and leap-years. To show the result in hours, format the result as Time field. :wink2:

Link to comment
Share on other sites

This topic is 5684 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.