View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default How to calculate overtime hours in Excel using formulas?

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

--
Kind regards,

Niek Otten

"Toeknee" wrote in message
...
I need information on how to enter the proper syntax (formula) so that
excel
can calculate overtime hours. In california over 8 hrs in one day is
overtime. The 8 would be considered regular hours and anything over is
OT.