<div>
Do you mean like this?<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/05_w21/1320180/Time-differnce.xlsx" target="_blank" class="file-inline" title="Time-differnce.xlsx (11.4 MB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Time-differnce.xlsx</a>
</div>


Do you mean like this?
Time-differnce.xlsx [https://filedb.experts-exchange.com/incoming/2018/05_w21/1320180/Time-differnce.xlsx]

Time-differnce.xlsx

<div>
Hi,<br />
<br />
A simple B - A formula should do it, and format your cell with a costum format, such as dd/mm/yy hh:mm:ss
</div>


Hi,

A simple B - A formula should do it, and format your cell with a costum format, such as dd/mm/yy hh:mm:ss

<div>
Hi Roy, <br />
<br />
Exactly, is that possible to reflect like 1 days and 15 Mints
</div>


Hi Roy,

Exactly, is that possible to reflect like 1 days and 15 Mints

<div>
I'll get back later, I'm a little busy at the moment
</div>


I'll get back later, I'm a little busy at the moment

<div>
Try a custom number format<br />
<br />
d &quot;days&quot; h &quot;hours&quot; mm &quot;minutes&quot;
</div>


Try a custom number format

d "days" h "hours" mm "minutes"

Time-difference.xlsx

<div>
This is a better formula... it will give you the total hours :<br />
<br />
=((NETWORKDAYS(A2,B2)-1)+(<wbr />IF(TIMEVAL<wbr />UE(B2)&gt;=TI<wbr />MEVALUE(A2<wbr />),TIMEVALU<wbr />E(B2)-TIME<wbr />VALUE(A2),<wbr />TIMEVALUE(<wbr />B2)-TIMEVA<wbr />LUE(A2)+1)<wbr />))*24<br />
<br />
Now, I don't know how you want to display it... <br />
<br />
1. &nbsp;1 day 2 hours 13 minutes<br />
2. &nbsp;26 hours 13 minutes<br />
3. &nbsp; 26.23 hours<br />
<br />
My above formula will display as number 3
</div>


This is a better formula... it will give you the total hours :

=((NETWORKDAYS(A2,B2)-1)+(IF(TIMEVALUE(B2)>=TIMEVALUE(A2),TIMEVALUE(B2)-TIMEVALUE(A2),TIMEVALUE(B2)-TIMEVALUE(A2)+1)))*24

Now, I don't know how you want to display it...

1.  1 day 2 hours 13 minutes
2.  26 hours 13 minutes
3.   26.23 hours

My above formula will display as number 3

<div>
Previous comment from author states how they want result displayed; as per number 1.
</div>


Previous comment from author states how they want result displayed; as per number 1.

<div>
This is prefect, Thanks a lot Rob.
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
Need help to calculate the date and time difference between two date in attached spreed sheet,(Excluding weekends)<br />
<br />
I have tired with multiple formulas but now working correctly, please help us,<br />
<br />
Thanks!<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/05_w21/1320106/Time-differnce.xlsx" target="_blank" class="file-inline" title="Time-differnce.xlsx (11.4 MB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Time-differnce.xlsx</a>
</div>
</div>


Hi Experts,

Need help to calculate the date and time difference between two date in attached spreed sheet,(Excluding weekends)

I have tired with multiple formulas but now working correctly, please help us,

Thanks!

How to calculate date &amp; Time difference between date and time

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.

How to calculate date &amp; Time difference between date and time

How to calculate date & Time difference between date and time