Time calc - Newbie question

[Jaman]

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 :)

[jteich]

Use timestamps instead.

-jens

[Jaman]

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.

[Teresa Sampaio]

Hi, Jaman,

I had a similar problem.

See my post #197367

[jteich]

set the timestamps simply by

Timestamp ( Get( CurrentDate ) ; Get( CurrentTime ) )

and subtract start_timestamp from stop_timestamp. The result is in seconds.

-jens

[LaRetta]

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:

[Jaman]

Got it...

Thanks :