The above example would be like this in Excel 2007. For example with start time of 900 AM and an end time of 500 PM you can simply use this formula. The 1 in the formula establishes Saturdays and Sundays as weekend days and excludes them from the total.
Typing TIME 14 30 10 produces.
Be sure to enter the hours using a 24-hour clock. Type time sheet into the search bar and press Enter. You dont specify the 1 because NETWORKDAYS assumes the weekend is on Saturday and Sunday. The 1 in the formula establishes Saturdays and Sundays as weekend days and excludes them from the total.