Solved

Subtracting two time columns to create hours

Posted on 2011-09-06
2
149 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:newbieweb
2 Comments
 
LVL 7

Accepted Solution

by:
redbmaster earned 500 total points
Comment Utility
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
 

Author Closing Comment

by:newbieweb
Comment Utility
Thanks!
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now