AnsweredAssumed Answered

Elapsed Time Calculation

Question asked by -bc- on May 25, 2009
Latest reply on May 26, 2009 by comment_1

Summary

Elapsed Time Calculation

Description of the issue

Filemaker Pro Advanced 10.0v1Windows Vista The problem occures when calculating elapsed time at the end/beginning of the day, eg., if start time = 11PM and end time = 12AM (midnight) end time - start time SHOULD = 1 hour, instead the result returned is -23:00:00.  On the other hand, if for a start time you use 12AM or 0AM for start time and 9AM for end time, the result of end time - start time returns 9 hour.  In fact 9AM -12AM SHOULD return the -23:00:00.  I understand the mathmatical quandry here but I think from a user interface prespective it makes more sense to make 12PM be the very last miniscule second of the day and 0 to be the starting instant of the new day.  That way you can have 24 hours in a day by subtracting start time (0) from end time (12PM).  Not Possible at the moment. Best regards, Bruce PS.  I hate reporting "annomallys" w/o also saying how great this program is.  I absolutely love it and I can easilly work around this problem BUT I'm trying to make an application where my users probably won't understand the "work around". 

Outcomes