Hi,
Take a look at C. Pearson web it has the answers you are looking for

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

If this was helpful please say yes, thanks

"Sala" wrote:

How do I calculate duty times and need to separate if any one is late and
their overtime