Solved

Subtracting two time columns to create hours

Posted on 2011-09-06
2
151 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
ID: 36490293
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
ID: 36490511
Thanks!
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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 article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

772 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