Solved

Subtracting two time columns to create hours

Posted on 2011-09-06
2
150 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

919 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

19 Experts available now in Live!

Get 1:1 Help Now