How do I add hours worked in exel
 

I work different times every week.I want to be able to total the hours worked
each day to include overtime for each week automatically. for example day
one I work from 2PM to 8 Pm .over time starts at 6pm. normal payment is
$25.00 overtime is 15%+
Thanks

How do I add hours worked in exel
 

To specifically address your question:
Cell A1 enter time in. Cell B1 time out. Cell C1 this:
=IF(B1<=0.75,(B1-A1)*24*25,(0.75-A1)*24*25+(B1-0.75)*24*25*1.15)
A better approach, though, is to get yourself a well designed timesheet.

"Wilfred" wrote:

I work different times every week.I want to be able to total the hours worked
each day to include overtime for each week automatically. for example day
one I work from 2PM to 8 Pm .over time starts at 6pm. normal payment is
$25.00 overtime is 15%+
Thanks

How do I add hours worked in exel
 

Assuming you don't work through midnight, and overtime rate begins at 6:00 PM
regardless of hours workd.

"Tevuna" wrote:

To specifically address your question:
Cell A1 enter time in. Cell B1 time out. Cell C1 this:
=IF(B1<=0.75,(B1-A1)*24*25,(0.75-A1)*24*25+(B1-0.75)*24*25*1.15)
A better approach, though, is to get yourself a well designed timesheet.

"Wilfred" wrote:

I work different times every week.I want to be able to total the hours worked
each day to include overtime for each week automatically. for example day
one I work from 2PM to 8 Pm .over time starts at 6pm. normal payment is
$25.00 overtime is 15%+
Thanks