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

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

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.

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

Steve

Its the number of the seconds in a day.

60 seconds x 60 minutes = 3600

HTH

Lee

Thanks again,

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

SF

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

See if this helps:

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