Thanks for linking that SamT.
I came across a nice formula today that works well in Google Sheets, and it gives me the number of minutes it takes to complete a job.
The formula only works on Monday to Friday though, so I'm missing 09:00am to 12:00pm on Saturday.
I'm wondering if I was to provide some data, and the expected results, maybe we can get Saturday working.
New formula is:
=SUM(IF(OR($H$20<$G$20,I6<D6),0,(NETWORKDAYS(D6,I6,HolidayList)-(NETWORKDAYS(D6,D6,HolidayList)*IF(MOD(D6,1)>$H$20,1,(MAX($G$20,MOD(D6,1))-$G$20)/($H$20-$G$20)))-(NETWORKDAYS(I6,I6,HolidayList)*IF(MOD(I6,1)<$G$20,1,($H$20-MIN($H$20,MOD(I6,1)))/($H$20-$G$20))))*($H$20-$G$20)*24)/24)*1440
So yeah... you can probably tell why I'm confused.
I'm not too familiar with Networkdays & Mod, so this is quite challenging for me.
As I would like to include Saturday, I imagine the Networkdays function will need to be changed to Networkdays.Intl ?? But, I still don't know how to go about adding the times, and getting the correct criteria.
Anyway, I would greatly appreciate some help on this if someone has some spare time.
Thank You very much.
I have uploaded a new spreadsheet.
Column L contains the new formula that needs Saturday adding.
Again, thank you for any help.