Profit Sharing Projects

Ted Penner

<div>
Thanks Neeraj,<br />
<br />
Each of the two columns C and D are formatted as ddd&quot; &quot;mm&quot;/&quot;d&quot;/&quot;yyyy,&quot; &quot;h:mm&quot; &quot;am/pm and the resulting duration should be in h:mm.<br />
<br />
The online sheet is here with the duration column designated by yellow coloring.<br />
<br />
<a href="https://docs.google.com/spreadsheets/d/1q_FcbxZmY9vGRzyggmPQQpinwzH8BFQwQIqBA9Op9SA/edit#gid=1552917037" rel="ugc">https://docs.google.com/spreadsheets/d/1q_FcbxZmY9vGRzyggmPQQpinwzH8BFQwQIqBA9Op9SA/edit#gid=1552917037</a><br />
<br />
Thank you for the assistance!
</div>


Thanks Neeraj,

Each of the two columns C and D are formatted as ddd" "mm"/"d"/"yyyy," "h:mm" "am/pm and the resulting duration should be in h:mm.

The online sheet is here with the duration column designated by yellow coloring.

https://docs.google.com/spreadsheets/d/1q_FcbxZmY9vGRzyggmPQQpinwzH8BFQwQIqBA9Op9SA/edit#gid=1552917037 [https://docs.google.com/spreadsheets/d/1q_FcbxZmY9vGRzyggmPQQpinwzH8BFQwQIqBA9Op9SA/edit#gid=1552917037]

Thank you for the assistance!

<div>
<div class="content wysiwyg-content">
Assuming that the data below is in columns C and D and I want to show the elapsed time in terms of hours and minutes (h:mm). &nbsp;How do I write a formula that fills that in when it sees a date/time format such as the one shown below in columns C and D<br />
<br />
Column C &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Column D<br />
Fri 02/9/2018, 8:14 PM &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Fri 02/9/2018, 8:15 PM
</div>
</div>


Assuming that the data below is in columns C and D and I want to show the elapsed time in terms of hours and minutes (h:mm).  How do I write a formula that fills that in when it sees a date/time format such as the one shown below in columns C and D

Column C                               Column D
Fri 02/9/2018, 8:14 PM	Fri 02/9/2018, 8:15 PM

Show elapsed time

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

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

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