BobWeaver Posted March 9, 2001 Share Posted March 9, 2001 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).] Link to comment Share on other sites More sharing options...
jnmorrison Posted March 10, 2001 Share Posted March 10, 2001 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8469 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 accountSign in
Already have an account? Sign in here.
Sign In Now