Subtracting two time columns to create hours

Using Excel 2007 I need to subtract two columns, each containing the time (military). I need the result to be hours (as a double).

What are the formulas and formatting I need to use?

Thanks.
newbiewebSr. Software EngineerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
redbmasterConnect With a Mentor Commented:
Ok, the formula to convert a time to an integer is (A1-INT(A1))*24. So the forumula should look something like =SUM(((A2-INT(A2))*24)-((A1-INT(A1))*24)).

To format a cell, just right click it and select "Format Cell".
0
 
newbiewebSr. Software EngineerAuthor Commented:
Thanks!
0
All Courses

From novice to tech pro — start learning today.