I have a series of date and time ranges that I need to show the differnence in Days, hours and minutes.
Example:
5/29/2013 9:37:36 PM / 6/3/2013 11:15:56 PM
I would like to see the difference in days, hours/ minutes. Excluding weekends.
Anyone know a good formula for this?
Hello craig, welcome to Excel Forum
If your dates are always weekdays then with start date/time in A2 and end date/time in B2 try this formula in C2
=NETWORKDAYS(A2,B2)-1-(MOD(B2,1)<MOD(A2,1))&" days "&TEXT(B2-A2,"h:mm")
for your example that will give the result
3 days 1:38
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks