Time

[Ricardo]

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.

[Geeksharka]

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

[RussBaker]

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.

[Ricardo]

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