there is starttime and endtime ,i want to calculate date and time neglecting sunday and i want to calculate time in hours and only consider 9 working hours per day?

[sumitjadhav]

there is starttime and endtime ,i want to calculate date and time neglecting sunday and i want to calculate time in hours  and only consider 9 working hours per  day?

[sunny_talwar]

May be something like this:

=Interval((Floor(WeekEnd(StartTime, 0, 0))-StartTime) + ((Floor(WeekStart(EndTime))-Floor(WeekEnd(StartTime, 0, 0)))*6/7) + (EndTime-Floor(WeekStart(EndTime))), 'd') * 9

The above is assuming that StartTime and EndTime are just dates.

[swuehl]

Here is a thread with some suggestions if you need to handle timestamps.

Re: Calculate hours between two Date/Time strings