View Single Post
 
Old 11-07-2013, 07:58 AM
Swooshy Swooshy is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Nov 2013
Posts: 7
Swooshy is on a distinguished road
Default Calculating turnaround times in excel

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!!
Reply With Quote