marshybid
07-30-2008, 01:58 AM
Hi All,
I have a very large spreadsheet that contains many columns of dates (essentially this is a cycle time report)
I need to calculate the working time (during work hours only) that each step in the process is taking.
xld kindly provided me with a formula to help in doing this however it soes not appear to be calculating as expected.
I have attached an example sheet containing the formula.
Column C contains the date and time that a request was submitted, Column F contains the date and time that this submittal was approved.
Column G should calculate the total time taken between these dates/times (only counting working days - Mon to Fri, and only counting hours between 08:00 and 18:00, as per the formula)
As you can see in the attachment, this does not appear to be working as the correct result in column G should be 0:4:39!!
Can anyone help please.
Thanks,
Marshybid
I have a very large spreadsheet that contains many columns of dates (essentially this is a cycle time report)
I need to calculate the working time (during work hours only) that each step in the process is taking.
xld kindly provided me with a formula to help in doing this however it soes not appear to be calculating as expected.
I have attached an example sheet containing the formula.
Column C contains the date and time that a request was submitted, Column F contains the date and time that this submittal was approved.
Column G should calculate the total time taken between these dates/times (only counting working days - Mon to Fri, and only counting hours between 08:00 and 18:00, as per the formula)
As you can see in the attachment, this does not appear to be working as the correct result in column G should be 0:4:39!!
Can anyone help please.
Thanks,
Marshybid