Remember Me?

#1
March 1st 06, 06:27 PM posted to microsoft.public.excel.misc
 Toeknee Posts: n/a
How to calculate overtime hours in Excel using formulas?

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.

#2
March 1st 06, 06:43 PM posted to microsoft.public.excel.misc
 Niek Otten Posts: n/a
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.

#3
March 1st 06, 06:54 PM posted to microsoft.public.excel.misc
 bpeltzer Posts: n/a
How to calculate overtime hours in Excel using formulas?

If the hours worked in a given day are in cell B2, the overtime hours are
calculated by =max(0,b2-8). Basically, just subtract 8 (the regular hours).
The max ensures that you don't post negative OT hours if the total hours is
less than 8.
--Bruce

"Toeknee" wrote:

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Driver Excel Worksheet Functions 5 November 7th 05 11:19 AM MEGTOM New Users to Excel 5 October 27th 05 03:06 AM Chenopod Excel Worksheet Functions 7 May 31st 05 04:21 PM Bass Mama1 Excel Worksheet Functions 1 February 9th 05 03:25 PM Chris Excel Worksheet Functions 5 January 18th 05 06:07 PM

All times are GMT +1. The time now is 07:59 AM.