Calculate time

[funkygoorilla]

yes thats correct I need the result to be just numeric. For example. The TimeReceived value is 0900, the TimeArrivedValue is 0905, and the TimeCleared value is 0930. Now I need this to display just 30, for how many minutes it would be from 0900 to 0930. The fields are all set up as numeric, as the Time field was giving me way to many issues. The tricky part is the after midnight calculation. In the end all I need is the correct amount of minutes.

[rpeare]

Here's my example.

[funkygoorilla]

Whoa, sweet that is exactly what I need it to do. Thanks so much. Now I just have to figure out how to get it into my form.

[rpeare]

Base your form on a query, in your query have the calculations that I've given you then just link the calculated fields into your form, and just for good measure lock them or better yet remove the tab stop so people aren't tempted to try and change them.

[funkygoorilla]

Hi, ok I finally got it. Thank you so much for your help. I can proceed with the rest of my DB now. I also learned a heck of a lot during this process. Thanks again!
Funky G.