I need to count the number of days to 4 decimal places for a change in status. For example, the start and end dates would be in the following format:
28/10/2013 13:39
11/11/2013 11:51
to give an answer like 9.925
The weekend dates would also need to be excluded however not every Saturday and Sunday as they may be worked from occasion so i would have a manual tab of the dates that I would like to exclude. I have tried using the networkdays formula and while it works it only returns whole numbers which is not completely fair or reflective on the actual time taken by the various departments.
Anybody able to share some expertise on this? If you need more info please let me know!!
Thanks in advance!!
28/10/2013 13:39
11/11/2013 11:51
to give an answer like 9.925
The weekend dates would also need to be excluded however not every Saturday and Sunday as they may be worked from occasion so i would have a manual tab of the dates that I would like to exclude. I have tried using the networkdays formula and while it works it only returns whole numbers which is not completely fair or reflective on the actual time taken by the various departments.
Anybody able to share some expertise on this? If you need more info please let me know!!
Thanks in advance!!