Forum Discussion
Calculating and expressing time worked as days hours minutes
I have issue opened 29/10/2018 10:15 and issue closed 04/11/2018 12:00 I want to express time worked on the issue as 3 days 5 hours 5 minutes I don't want to count time outside 5pm or before ...
I can't do it.. how do I embed the networking days and the holidays into the suggested formula
=INT(J2-E2)&"days"&TEXT(J2-E2,"h""hrs""m""mins""") ?
As variant
=NETWORKDAYS(A5+1,B5-1,HolidayList) & " days " & TEXT(B2-(A5-INT(A5))+B5-INT(B5)-A2,"h"" hours ""m""minutes""")
but shall be modified if hours in first and last days are more than 8 hrs in sum and you'd like to consider them as 1 day plus some time, not sure about business logic here. Please see attached.