View Single Post
  #1   Report Post  
nobodylikeyou nobodylikeyou is offline
Junior Member
 
Posts: 1
Default help with subtracting time excluding weekends and non-working hours

hi i need help , i tried some formulas around but im not getting the results

i want to count the working hours from date 1 to date 2 with subtracting non working days (weekends) and non working hours. working hours in a day should be 9 hours, no specific start hour or end hour

start day and time
6/4/2010 11:37

end day and time

6/9/2010 16:10

results should be :
31:32:28

please can someone help me out over here, i need this to be done for work