Newbies jetb2 Posted November 7, 2000 Newbies Posted November 7, 2000 I'm brand new to FileMaker and I can't find a solution to this problem. I've looked through the manual and through the help files. I want to be able to subtract the time some one started a task from the time that they finished the task to show the duration of the task. I am currently just subtracting the two and its not working correctly. Is there a formula I can use and if so what is it and where do I type it in. Thanks, Jim
Chuck Posted November 7, 2000 Posted November 7, 2000 When you subtract two times, you get the difference between the times in seconds. If the two times are always in the same day, and you want to know how many hours the difference is, just divide your original difference by 3600, the number of seconds in an hour. Chuck [This message has been edited by Chuck (edited November 06, 2000).]
Chuck Posted November 7, 2000 Posted November 7, 2000 quote: Originally posted by jetb2: I'm brand new to FileMaker and I can't find a solution to this problem. I've looked through the manual and through the help files. I want to be able to subtract the time some one started a task from the time that they finished the task to show the duration of the task. I am currently just subtracting the two and its not working correctly. Is there a formula I can use and if so what is it and where do I type it in. Thanks, Jim When you subtract two times, you get the difference between the times in seconds. If the two times are always in the same day, and you want to know how many hours the difference is, just multiply your original difference by 3600, the number of seconds in an hour. Chuck
Recommended Posts
This topic is 8886 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