I am looking for a formula that would calculate how many minutes someone
was late.

For example: If an employee's schedule was 9:00am-5:00pm and they
arrived after 9:07am but before 9:22am they would be charged .25hrs, if
they arrived after 9:23am but before 9:37am they would be charged .50hrs
and so on.

Since we have many different work schedules it would be great to figure
out how to create a formula for these calculations... a formula to
calculate the time charged. I have Excel 2000. Does anyone know how
to do this? Please help!

Thanks


--
Padovan
------------------------------------------------------------------------
Padovan's Profile: http://www.excelforum.com/member.php...o&userid=26432
View this thread: http://www.excelforum.com/showthread...hreadid=397015