<div>
Assuming A1 and A2 have dates in them, and A1 &gt;&nbsp;A2<br />
<br />
A3 has &quot;=A1-A2<br />
<br />
Now apply custom format like this to A3<br />
<br />
&quot;days&quot; dd &quot;hours&quot; hh &quot;minutes&quot; mm &quot;seconds&quot; ss
</div>


Assuming A1 and A2 have dates in them, and A1 > A2

A3 has "=A1-A2

Now apply custom format like this to A3

"days" dd "hours" hh "minutes" mm "seconds" ss

<div>
you could do a macro using VBA in excel to do what you want to achieve, I think that would make things easier for you because then you could work it out exactly how you want to.
</div>


you could do a macro using VBA in excel to do what you want to achieve, I think that would make things easier for you because then you could work it out exactly how you want to.

<div>
I also found this website, I hope it helps !<br />
<br />
<a href="http://www.mathtools.net/Excel/Time_and_Date/" rel="ugc">http://www.mathtools.net/Excel/Time_and_Date/</a>
</div>


I also found this website, I hope it helps !

http://www.mathtools.net/Excel/Time_and_Date/ [http://www.mathtools.net/Excel/Time_and_Date/]

<div>
you have to register with that website I just posted, just so you know. The URL for the function to work out the time , date diff is below. I think that was done in VBA.<br />
<br />
<a href="http://www.barasch.com/excel/daymoyear.htm" rel="ugc">http://www.barasch.com/excel/daymoyear.htm</a>
</div>


you have to register with that website I just posted, just so you know. The URL for the function to work out the time , date diff is below. I think that was done in VBA.

http://www.barasch.com/excel/daymoyear.htm [http://www.barasch.com/excel/daymoyear.htm]

<div>
Thanks for the quick response. &nbsp;Looks like this will work great.
</div>


Thanks for the quick response.  Looks like this will work great.

<div>
<div class="content wysiwyg-content">
Hopefully someone has done this. &nbsp;I am looking for the formula to calculate the difference between one date time and another. Converting to days, hours and minutes. &nbsp;I can do it in VB but need to be able to do it in EXCEL. &nbsp;Any suggestions?
</div>
</div>


Hopefully someone has done this.  I am looking for the formula to calculate the difference between one date time and another. Converting to days, hours and minutes.  I can do it in VB but need to be able to do it in EXCEL.  Any suggestions?

Use EXCEL to calculate time differences

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.