2 Replies Latest reply: Jan 12, 2016 8:04 PM by Stefan Wühl

# 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?

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?

• ###### Re: 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?

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.

• ###### Re: 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?

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

Re: Calculate hours between two Date/Time strings