<div>
Yes you're right. <br />
Indeed u:mm should be h:mm. That was a language issue/setting. <br />
Selecting 13:30 gives me the same as h:mm.<br />
<br />
I'm glad you figured it out and I could give you a starting point.
</div>


Yes you're right.
Indeed u:mm should be h:mm. That was a language issue/setting.
Selecting 13:30 gives me the same as h:mm.

I'm glad you figured it out and I could give you a starting point.

<div>
I selected my own comment as teh solution because the other solution was only partially correct. It did jump start what I found to be the complete solution of what I was looking for.
</div>


I selected my own comment as teh solution because the other solution was only partially correct. It did jump start what I found to be the complete solution of what I was looking for.

<div>
<div class="content wysiwyg-content">
I have a spreadsheet that I am working on that displays the following information<br />
A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;G<br />
Time In &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Time Out<br />
8:00 AM &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5:00 PM<br />
8:00 AM &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3:29 PM<br />
<br />
<br />
I want it to display the hours between the 2 in column G. 9 hours for the first row and 7 hours 29 minutes for the second. Is that possible, what is the best way to do it?<br />
<br />
I am using Excel 2010.
</div>
</div>


I have a spreadsheet that I am working on that displays the following information
A               B                                                              G
Time In 	Time Out
8:00 AM	5:00 PM
8:00 AM	3:29 PM


I want it to display the hours between the 2 in column G. 9 hours for the first row and 7 hours 29 minutes for the second. Is that possible, what is the best way to do it?

I am using Excel 2010.

Excel Macro

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.