Timesheet formula

[Curly_Coy]

Hi All,

Trying to set up the following in 2010 excel.

If a worker, works a Saturday then works a Sunday, then Sunday time is calculated at double time.

But if the worker, only works the Sunday (no Saturday), then the first 10 hours is at time & half, then double time after that.

Help please.

 

[texasalynn]

post a sample of your data with how the time is reported