Hi All,

If I have Total House in A1 and I want B1 to show me Regular Hours and C1 To take out remaining Hours as Overtime and show me.

here In my country we have OFF on Fridays but still Fridays are paid as regular Hours
Regular working Hours are 8 and the above all is calculated as Overtime.
Monthly Total Regular Hours are 248 (8x31=248)

Suppose...
If A1 is showing Total 288 Hours...
So B1 should show 248 but how???
And C1 should show the remaining 40...

I want to know the formula or anyhow needs that to be done for my work purpose.

thanks in advance guys.

regards,
IFFY