Date and Time

[trevors]

I have 4 fields ...

Date Start

Time Start

Date Finish

Time Finish

I want to calculate the difference in Hours and minutes between them (this is either very simple and I missed it, or very complex ... for me anyway).

The dates: I have a Mini Calandar for user to update.

The Time field: Pop-up list in 1/2 hour blocks (24 hours).

Or is this the wrong way to even start?

[comment]

This formula:

( EndDate - StartDate ) * 86400 + EndTime - StartTime

will return the difference in seconds. If you set the result type to Time, it will display as h::mm::ss (or whatever time format you select for the field in Layout mode). The method you use to input data into the fields does not matter to the calculation.

[trevors]

Thank you very much ... this one is busted thanks to you. It was not as hard as I thought, I was kinda on the right track, you just saved me many hours of work before I worked it out - Like 2-3 days:-)

Again Thanks

Trevors