calculating time, overtime in excel [h]:mm format

I

iamtaranicole

I am trying to complete a spreadsheet in hour and minute format that will
calculate the overtime for each employee over 40 hours. If I have someone
with 45:30 hours and want to have excel calculate the hours of overtime in
the next column What formula would I use?
=MAX(0,D35-40) doesn't work
=IF($D35>40,SUM($D35,-40)," ") doesn't work
 
N

Niek Otten

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am trying to complete a spreadsheet in hour and minute format that will
| calculate the overtime for each employee over 40 hours. If I have someone
| with 45:30 hours and want to have excel calculate the hours of overtime in
| the next column What formula would I use?
| =MAX(0,D35-40) doesn't work
| =IF($D35>40,SUM($D35,-40)," ") doesn't work
 
I

iamtaranicole

=IF(D36>$D$1,D36-$D$1," ")
Thanks everyone This formula worked also where $d$1=40:00
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complex Timesheet 10
Overtime 4
Overtime for 8 hour and 40 hour 1
Payroll Calculation - Help Needed 3
Excel Timesheet Error 2
straight time, time and a half, and double time 3
If Formula 2
Need Formula to Calculate Time/Overtime 2

Top