Thread: calculating working hours between 2 dates
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming,microsoft.public.excel
Stan Brown Stan Brown is offline
external usenet poster
  
Posts: 524
Default calculating working hours between 2 dates
Sat, 26 Jan 2008 11:45:20 +0200 from Jani Ruohomaa
:
Does anyone know how to calculate working hours between 2 dates ?

Look in Help for NETWORKDAYS, and multiply by the number of working
hours per workday.

You will need Analysis Toolpak if it's not already installed.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/
Reply With QuoteReply With Quote