Hi,

I have a query about calculating the numbers of hours worked using a formula.

In essence I have a start and end date/time which I can happily subtract from each other to get a the number of hours. BUT, I want to be able to automatically calculate the amount of time spent between two times BUT only where it falls in a 8am - 4pm range.

For example, if a user starts a piece of work at 3pm on 1 day and then continues it the next day from 8am and finishes at 10am I want to be able to make sure it calculates this as 3 hours and not 19 hours which it would do with a straight subtraction.

Does this make sense?

Regards