Need calculate expression for comparing two times

GrooperGuru

I have a table with three columns: Start Time, End Time, and Total Hours.
Start/End Time are presented in military time on the document... example: "16:20"
Total Hours is represented in hours as a decimal... example: "2.5"

I need a calculate expression to be placed on the Total Hours field that will figure out the difference of the times and convert that difference from minutes to a decimal format, but my .NET skills are total boo boo. I'm sure this is a simple question for the programmers out there.

Brian

Here you go @GrooperGuru.  This should do the trick:

DateDiff(DateInterval.Minute, Start_Time, End_Time) / 60.0

GrooperGuru

FYI, this almost worked. But it was throwing an exception. I did some research online and it suggested that each time being considered (in this case Start_Time and End_Time) needs to be wrapped in CDate(). So for me, the final expression ended up as below. Will add to master expression lists.

DateDiff(DateInterval.Minute, CDate(Start_Time), CDate(End_Time)) / 60.0