ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I calculate difference in days & hours between two dates e. (https://www.excelbanter.com/excel-worksheet-functions/9093-how-do-i-calculate-difference-days-hours-between-two-dates-e.html)

probi2

How do I calculate difference in days & hours between two dates e.
 
How do I calculate difference in days & hours between two dates excluding
weekends and public holidays. Using excel 2002

JulieD

Hi

check out
http://www.cpearson.com/excel/DateTimeWS.htm#WorkHours

i think it might be what you're looking for

Cheers
JulieD

"probi2" wrote in message
...
How do I calculate difference in days & hours between two dates excluding
weekends and public holidays. Using excel 2002





All times are GMT +1. The time now is 08:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com