Calculating Hours

Posted by John on May 12, 2001 2:26 PM

I am trying to create a worksheet that will calculate employees' hours, deducting OT hours (where applicable), and running theie gross earnings based on their hourly wages.

Does someone know a quick way to set this up?

Thanks!

~John

Posted by Kevin James on May 12, 2001 5:02 PM

Hi John,

What do you have so far?

Kevin

Posted by Mark W. on May 13, 2001 1:39 PM

Regular hours can be calculated using the formula,
=MIN("40:00:00"+0,SUM(work_hours)), where "work_hours"
is a cell reference to the recorded hours worked.

Overtime hours can be calculated using the formula,
=MAX(0,SUM(work_hours)-"40:00:00").