Error calculating the hours and minutes between 2 times

[exflyer1996]

The Start Time and End Time are exporting from our database in the following formats:

6:52:00 AM and 3:32:00 PM (although this displays in Military Time).

What I want to do is sum the time between the 2 in an hours and 10th of an hour format, so that a SUMIF formula will pull in the hours. Ideally, I like to be able to format the SQL file so that it calculates the time when I execute the query.

Many Thanks

 

[Rick Rothstein]

I don't know SQL, but if your earlier time is in cell A1 and your later time is in cell B1, the following formula will give you the hours rounded to the nearest tenth of an hour...

=ROUND(24*(B1-A1),1)

 

[exflyer1996]

Thanks. That worked just fine.