Help with time calculation

[Baylah]

If 16:00 - 14:30 = 90 minutes how can I write a formula based on two time fields that returns a result in minutes.

e.g. 3 fields

Time_out - Time_in = Elapsed_time

Essentially I would like 16:00 - 14:30 to = 90 instead of 1:30:00 which is my FMP result.

If I get the return of 90, I can then divide it by 60 to get a result of 1.5 which is my ultimate desire. The expression above returns 1.5 hours instead of 1:30.

Any help would be greatly appreciated.

Thanks,

Steve

[Lee Smith]

if the day is the same for start and finish, the calculation is

(finish_Time - Start_Time) /3600

However, if you are starting and finishing on different days, you should make your fields Timestamps, or include the day start and day end in the calculation.

HTH

Lee

[comment]

If I get the return of 90, I can then divide it by 60 to get a result of 1.5 which is my ultimate desire.

Divide by 3600 and make the result type Number.

[Baylah]

Thanks a bunch...works perfect....where does the 3600 come from?

Steve

[Lee Smith]

Its the number of the seconds in a day.

60 seconds x 60 minutes = 3600

HTH

Lee

[Baylah]

Thanks again,

I was very needlessly using math far more complicated than that!

SF

[Brian Garrett]

I know I'm replying to an old post, but the thread on here is totally going down the road of what I'm trying to figure out. I'm working on a db that needs to have a start time an end time and a calculation of the total time spent working. There are some events that will be worked starting on one day and ending on the next. I'm not very clear on how I would make a user enter in the time when using Timestamps as the field. I thought Timestamps were only used through more of an auto-enter process.

Any suggestions on where I can look for sorting this part out?

Thanks in advance...

Brian

[comment]

See if this helps:

http://fmforums.com/forum/topic/49853-time-calculations/page__p__233345#entry233345