Hi,

First, you are underpaying your people.

Here is a formula that does that:

Assume that the 7:30 is entered in B1 and 7:33 is in C1 then:

=10-IF(C1B1,ROUNDUP((C1-B1)*24*60/5,0),)


--
Thanks,
Shane Devenshire


"Larry" wrote:

I have a worker who gets $10 daily for a job, but he's got to be there
promtly @7:30am. For each 5 minutes late, $1.00 is docked.

I'd like to be able to enter into the cell 7:33am and this will bring up
$9.00. 7:37am 8.00 and so on.

Any help for setting this up would really be appreciated.

Thanks all