Calculate number of hours between dates and times excluding Weekends

[princy_varghese]

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

 

[Fred Smith]

Your requirements contradict each other. So let's deal with one at a time.

If your start date/time is in A1, and your end time is in A2, the number of
hours difference is:

=(a2-a1)*24 [format as a number]

As there are 24 hours in a day, you can also simply check to see if the
difference is more than one day.

So your if statement might look something like:

=if(a2-a1>1,"Exceeded","Not Exceeded")

With respect to weekends, how can you exclude weekends in the calculation, but
then need to know if you've crossed into a weekend? We need at better definition
of what you consider a weekend. For example,

-- is it a time period of >48 hours?
-- does it start at, say, 6pm on Friday?
-- does it end at, say, 8am on Monday?