ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   help with subtracting time excluding weekends and non-working hours (https://www.excelbanter.com/excel-worksheet-functions/265436-help-subtracting-time-excluding-weekends-non-working-hours.html)

nobodylikeyou

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