Forum Discussion
NETWORKDAYS formula
Hi, hoping someone can help I have two dates which I need to calculate the difference between the two date and time fields, I also need to exclude weekends. Start Date format dd/mm/yyyy hh:m...
so, you want actual NETWORKTIME meaning you want to exclude weekends and holidays AND know number of HOURS & MIN. I think you should be able to:
= NETWORKDAYS(...) - 1 + TIME([end]) - TIME([start])
That said, this does NOT take into account WORK HOURS (e.g. 9:00am - 5:00pm)
= NETWORKDAYS(...) - 1 + TIME([end]) - TIME([start])
That said, this does NOT take into account WORK HOURS (e.g. 9:00am - 5:00pm)