Thread: Time to process
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CASBMS CASBMS is offline
external usenet poster
 
Posts: 1
Default 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?