Time...how do I....

[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

[Chuck]

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]

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