Posted to microsoft.public.excel.misc

iamtaranicole iamtaranicole is offline

external usenet poster

Posts: 3

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

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($D3540,SUM($D35,-40)," ") doesn't work

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calculating overtime	Chase Michaels	New Users to Excel	1	May 16th 07 04:43 PM
Calculating overtime	bunnyc	Excel Discussion (Misc queries)	1	February 21st 06 12:36 AM
Calculating Overtime	sam13484 via OfficeKB.com	Excel Worksheet Functions	1	February 3rd 06 03:20 PM
help with calculating overtime in a time sheet	jongyrocka	Excel Discussion (Misc queries)	13	December 10th 05 09:36 PM
Calculating overtime	jennerifw	New Users to Excel	3	August 9th 05 08:33 PM

All times are GMT +1. The time now is 12:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us