<div>
When I format the cell to show hh:mm &nbsp;I get 864:00
</div>


When I format the cell to show hh:mm  I get 864:00

<div>
Think this will work<br />
=TEXT(E2-D2,&quot;h:mm:ss&quot;)
</div>


Think this will work
=TEXT(E2-D2,"h:mm:ss")

<div>
Should have also said, need to include the square brackets around the hh to get hours to keep going when over 24 and not go back to zero as a clock would.<br />
<br />
Thanks<br />
Rob H
</div>


Should have also said, need to include the square brackets around the hh to get hours to keep going when over 24 and not go back to zero as a clock would.

Thanks
Rob H

<div>
unless you have a specific reason then using TEXT function is probably not a good idea - just subtract like<br />
<br />
=E2-D2<br />
<br />
....then format as Rob suggests<br />
<br />
regards, barry
</div>


unless you have a specific reason then using TEXT function is probably not a good idea - just subtract like

=E2-D2

....then format as Rob suggests

regards, barry

<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
Does anyone know of a way to sum up the duration of two time periods. &nbsp;I would like to show, hh.mm.<br />
<br />
Here is the data:<br />
EVENTSTARTTIME &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;EVENTENDTIME<br />
Oct 03, 2011 10:59:00 AM &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Oct 03, 2011 11:34:48 AM<br />
Oct 03, 2011 02:30:00 PM &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Oct 03, 2011 02:55:00 PM<br />
<br />
I was using <br />
=ROUND((E2-D2)*1440,0) with gives me 36 hrs I would like 36.XX
</div>
</div>


Experts,

Does anyone know of a way to sum up the duration of two time periods.  I would like to show, hh.mm.

Here is the data:
EVENTSTARTTIME	EVENTENDTIME
Oct 03, 2011 10:59:00 AM	Oct 03, 2011 11:34:48 AM
Oct 03, 2011 02:30:00 PM	Oct 03, 2011 02:55:00 PM

I was using 
=ROUND((E2-D2)*1440,0) with gives me 36 hrs I would like 36.XX

EXCEL: FORMULA FOR TIME CALCULATION HH.MM

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

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

An office suite is a collection of bundled productivity software (a software suite) intended to be used by knowledge workers. The components are generally distributed together, have a consistent user interface and usually can interact with each other, sometimes in ways that the operating system would not normally allow. Most contain a word processor, a spreadsheet, an email client and presentation software; some might contain a database program. Several office suites have their own topics: Microsoft Office, Office 365, LibreOffice (also known as OpenOffice), Lotus IBM and Google Apps.