ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Time to process (https://www.excelbanter.com/excel-discussion-misc-queries/132570-time-process.html)

CASBMS

Time to process
 
I am trying to figure process time to process bewtween date adn time in .25
hours. I am using the following formula.

=CEILING((B3-F3)*24,0.25)

Does anyone know how to take holiday and weekends out of the total process
time?


All times are GMT +1. The time now is 07:29 AM.

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