# How to calculate overtime hours in Excel using formulas?

1. ## 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. ## Re: How to calculate overtime hours in Excel using formulas?

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

--
Kind regards,

Niek Otten

"Toeknee" <Toeknee@discussions.microsoft.com> wrote in message
news:B90A888E-AC70-4FB7-9A25-1EDF256709A9@microsoft.com...
>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. ## RE: 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.

4. ## Re: How to calculate overtime hours in Excel using formulas?

Having Problem to compute my Overtime in Hours

Let Say
A1 = time In 06:00
B1 = time Out 22:00
C1 = Overtime ?????Formula

Thanks

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1