R
Ryan Vande
Im working with excel, project, and access
I am in the end going to need to compare project task start timand end time.
I want to see if the time that spans between the two extend over a weekday.
or between our companys production time.
monday through friday 06:00 - 18:00 is non production hours
I have it coded now to identify start time & end time under the criteria
specified above but if the time spans from monday 5:00 am - 6 pm it dose not
count this
any ideas how I can see the time span from say monday 5 am -
monday 6 pm
I have conditions setup now that identify if start time >= 06:00 or start
time <= 18:00 same for finish time
but this will not calculate if datespan is extended over x amount of days or
if the hours extend over our production time
any help please
Thanks in advanced
regards,
I am in the end going to need to compare project task start timand end time.
I want to see if the time that spans between the two extend over a weekday.
or between our companys production time.
monday through friday 06:00 - 18:00 is non production hours
I have it coded now to identify start time & end time under the criteria
specified above but if the time spans from monday 5:00 am - 6 pm it dose not
count this
any ideas how I can see the time span from say monday 5 am -monday 6 pm
I have conditions setup now that identify if start time >= 06:00 or start
time <= 18:00 same for finish time
but this will not calculate if datespan is extended over x amount of days or
if the hours extend over our production time
any help please
Thanks in advanced
regards,