View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] princy_varghese@hotmail.com is offline
external usenet poster
 
Posts: 7
Default Calculate number of hours between dates and times excluding Weekends

Hi I need to calculate the number of hours between two dates and times
excluding weekends. I would assume this requires a VB code but not too
familar with it, can anyone help.

For .e.g:

Start Date: - 23/10/06 12:30
End Date: - 25/10/06 11:30

The code should calculate if the difference is 24 hours or more and
display a message Exceeded or if it is less say not exceeded but if it
has crossed over the weekend then say, Weekend.

Can anyon please help!!!

Thanks
Princy