Calculating hours... help!

[Dean Redding]

Hi,

I am racking my brain trying to calculate the hours between 2 times.

For example, I want to know how many hours between 7pm and 12am.

I know it's 5 hours, but I am getting -7:00 hours.

The calculation is not realized that it has changed days.

Any calculations before 12am is correct, but it won't add properly when I go after 12am.

Can anyone help me please?

[Dean Redding]

forgot to mention that I using 2 fields.

a field called "Start Time" & "End Time"

Cheers

Dean

[comment]

See if this helps.

[Dean Redding]

worked a treat! thanks for making my mind sane!!

Thank you