Find out total working hours between two dates with time excluding saturday & sunday?

[Ramesh Deo]

Hi, Excel Ninja,


please help me out to find total working excluding sunday & saturday between two dates with time.please see the sample uploaded.

thanks

 

[Mike H..]

Hi, Excel Ninja,


please help me out to find total working excluding sunday & saturday between two dates with time.please see the sample uploaded.

thanks

Hi,

I assume here that by working you mean within a working day e.g. between (say) 08:00 - 16:00. See the attached workbook, change the working day to the correct times in d1 and d2.

 

[Ramesh Deo]

hello mike,
i have given already time with date in uploaded file,then what about di and d2..