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 ...
Hi Georgie,
General idea is here https://exceljet.net/formula/get-days-hours-and-minutes-between-dates. To suggest concrete formula for your case could you please clarify how did you receive 3 days 5 hours 5 minutes in your sample - you have 4 workdays in between plus 06:45 on first day and 3 hours of work time on last day
Thanks very much for this, if I embed network days I should be able to make it work