Time Calculations

[nbrown]

I'm working on a calculation that will take two times and determine how many hours & minutes are between them. For example if I input 13:11 and 13:25 the calculation has to determine there is 14 minutes between the two values.. or 13:00 and 15:00 it needs to determine there are two hours between. The calculation that I'm currently using is not functioning properly it just keeps returning a -20. Any body out there that will show me the light?

Thanks, Nic

[andygaunt]

OK. Calc is

End Time - Start Time.

Format as time.

This will determine the time difference.

Will not work if you go over into the next day though.

but as simple as I can get it, this works.

[RussBaker]

Over more than one day, I use these fields

StartDate, in date format

FinishDate, in date format

StartTime, in time format

FinishTime, in time format

Duration, in time format, calc field

Then, the Duration is

code:

---

Duration = (FinishDate-StartDate)*86400 + (FinishTime-StartTime)

Russ Baker

[nbrown]

Excellent! Worked nicely. Thanks for your help.