July 16, 200223 yr Hi everyone, i need to calculate how long a job takes from start to finish. problem i have - jobs take longer than 1 day and if the job goes over in to next day or three days ahead it does not give a true representation of how long the job took. e.g.1. Start day 1 @ 1600 Finish day 2 @ 1500 result = -1 hr e.g.2. Start day 1 @ 1600 Finish day 3 @ 1700 result = +1 hr Can anyone help me please? Thanks in Advance, ricardo.
July 16, 200223 yr There are probably many many ways of doing this. I attached a sample file (timetest.fp5) where all you need to do is enter starting and ending days/time, and it shows you the difference in days/hours/minutes. Use and plunder at will. timetest.fp5.zip
July 16, 200223 yr You need to take into account the start and finish dates as well, so the calc for the time difference would be: (FinishDate-StartDate)*86400 + FinishTime - StartTime Format the result as a time field and your answer will be in hh:mm or hh:mm:ss If you want a different format to the standard Filemaker time formats, format the result as a number (it will be in seconds) and then start dividing by 60, 3600 etc if you want whole hours, minutes or whatever.
July 16, 200223 yr Author Cheers Mate, What i had worked out this morning already after i posted my thread believe it or not is basically exactly the same as the db you sent me. Two great minds think alike!! Enjoy the surf! Muchas Gracias, Ricardo
Create an account or sign in to comment