Timesheet formula

IndCom · #1 05-26-2011, 02:51 PM

Quote:

Originally Posted by Colin Legg

In C5

Code:

=B5+(A5>B5)-A5-D5

Gave a value of -1.67 in both the 12hr and 8hr shifts

In D5

Code:

=MAX(0,B5-A5+(A5>B5)-1/3)

Gave a value of 0.17 in the 12hr shift, but 0.0 in the 8hr shift

EDIT: This is a solution to the information in post #3. It does not account for differing overtime hours on weekends; it assumes 8 hour shifts.

Think I've tried that one before. Any other help and ideas are appreciated!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PMT Formula	OneOleGuy	Excel	4	03-05-2011 09:54 AM
Help with Formula	Corca	Excel	6	02-22-2010 09:40 PM
Timesheet formula help	beardking	Excel	2	11-10-2009 02:06 AM
If formula	sixhobbits	Excel	1	10-02-2009 08:02 AM
Help for formula	dehann	Excel	5	05-01-2009 10:44 AM