Using Networkdays with the Now() function to work out lapsed time since job was logged.

Originally Posted by MarkyP18

=(NETWORKDAYS(BQ2,NOW()-1)*("16:30"-"08:00")+IF(NETWORKDAYS(NOW(),NOW()),MEDIAN(MOD(NOW(),1),"16:30","08:00"),"16:30")-MEDIAN(NETWORKDAYS(BQ2,BQ2)*MOD(BQ2,1),"16:30","08:00"))

This looks like one of mine....

It's almost correct but you have some parentheses in the wrong places which will make a crucial difference - there should be a closing parenthesis after the first NOW() function and only one closing parenthesis at the end, like this

=(NETWORKDAYS(BQ2,NOW())-1)*("16:30"-"08:00")+IF(NETWORKDAYS(NOW(),NOW()),MEDIAN(MOD(NOW(),1),"16:30","08:00"),"16:30")-MEDIAN(NETWORKDAYS(BQ2,BQ2)*MOD(BQ2,1),"16:30","08:00")

It should work OK with NOW(), the expected input in those positions is a date/time