Time and date calculations

[Bob]

I need to calculate the total overall time a person worked. This may overlap
two or three days.

i need to make sure that they get at least an 8 hour break between work
periods also.

Is there a calcuation that would do that for me?

Thanks in advance

 

[Peo Sjoblom]

Try to adapt this

http://www.cpearson.com/excel/DateTimeWS.htm