Microsoft Office Forums - View Single Post - [Solved] Timesheet formula

Thread: [Solved] Timesheet formula

View Single Post

Old

05-26-2011, 02:42 PM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

In C5

Code:

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

In D5

Code:

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

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.

Reply With Quote