Time as decimal

[jasonwood]

I have two time fields, start time and end time.

I want to have a third field that calculates the number of HOURS in decimal format.

So if the difference between the time fields is 1:30, the calculation field would be "1.5"

Any help?

[jasonwood]

Sometimes asking the question is all it takes to figure it out...

Here's what I came up with:

(

 ( ( Hour ( logTimeEnd ) * 60 ) + Minute ( logTimeEnd ) ) - 

 ( ( Hour ( logTimeStart ) * 60 ) + Minute ( logTimeStart ) )

) / 60