I need help and im not sure where to start. I have a very large spreadsheet that I need to calculate the difference between 2 dates dependant on times.
My variables are:
if before 2p and same day = "0"
if after 2p and same day = "-1"
if after 2p and next day = "0"
if after 2p and not the next day = # of days past 1
if before 2p and not the same day = # of days past 1
Plus I need to take into account networkdays (weekends and holidays)
Can this even be done? Ive been playing around with if(and), if(or) and networkdays all day, but I cannot get everything.example.xlsx
Bookmarks