moegecko

Posts: n/a

i need help with a calculation formula...

if E1:E12 (each) cell is equal to more than 9.5, I need L12 to equal the
cells minus 9.5 - i'm trying to get my worksheet to calculate overtime hours
for our employees

for example E1 is 10.5, E2 is 9.5 , E3 is 10...I need L12 to show 1.5 in
overtime hours. I'm not sure is excel can calculate this way, but if it can
I would surely appreciate any input!

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
Again-revealing the contents of formula	srinivasan	Excel Worksheet Functions	0	July 5th 05 06:25 AM
Initial Formula Calculation	jestersdead	Excel Discussion (Misc queries)	3	July 4th 05 02:07 AM
Formula works in some cells, doesn't in other	Wowbagger	New Users to Excel	13	June 30th 05 03:21 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us