I just recieved microsoft 2007, I was using 03 before. Someone created a
formula to calculate a date cycle time that took in consideration the 8 hour
work day as well as the weekends. It won't work in the new version of excel,
I get a #NAME? error. I can't figure out how to create the formula. Here is
the old one:
=IF(E2="Closed",workhours(B2,C2),"")
Our company's servers also just moved to a different time zone, mountain, so
all of the issues are date time stamped 2 hours off, we are in the eastern
time zone. So I need to calculate that as well. Can anyone help me. I have
a report due by 5 today and I can't get it figured out. Thank you!