![]() |
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 |
All times are GMT +1. The time now is 02:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com