Maybe

=IF(K1=TIME(9,7,0),INT((K1-TIME(9,7,0))*24*4)+1,0)*25

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Padovan" wrote in
message ...

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