Date & Time Duration

[BobWeaver]

Duration = 86400 * (EndDay - StartDay) + EndTime - StartTime

Duration is in seconds. To get days, and hours minutes and seconds:

Days = Int(Duration / 86400)

HMS = Mod(Duration, 86400)

Days should be a number calculated field

HMS should be a time calculated field so that it formats as HH:MM:SS.

[This message has been edited by BobWeaver (edited March 09, 2001).]

[jnmorrison]

Here's my problem...

I have several different departments that need to check items in and out. Let's just look at one department.

I have a "Start_Date" and "Start_Time"

I also have an "End_Date" and an "End_Time"

Items that flow through these departments may stay there 10 minutes or 10 days. I need to calculate the time the item spent there, expressed in days and time.

Days are easy, using the DayofYear function, then subtracting. Time is much harder, since it's based on a 24 hour clock.

Please help!!!

------------------

Jeff M