Calculating Working Hours, Days and Overtimes.

I

icocelli

I would like a Microsoft Excel formula expert to help me please
because I need a excel formula or program that can calculate my
working hours and days for every 4 week.

I am working for company and like to calculate my own working days,
hours worked, over time and Sunday bonus.

For example let say I work these days and hours every week.

Company Payment Weekly Rate:
( Hourly Rate: Mon – Sat : £6.00

Sun - £7.00 )

So Lets say I work:

Mon (17:00pm to 00:00pm) with 30 minute break no pay for break

Sun (7:00am to 15:00 pm) with 30 minute break no pay for break.

Excel should calculate for me every 4 week by each week on the days
and hours I have giving with the payment rate above.

Plus: Overtime calculation and Tax calculate.
Pls help as this looks. I do not know how to start.please tell me how
can i start. i dont know nothing about excel.

if you have this calculation on excel or on other programs please
email on (e-mail address removed)
 
N

Niek Otten

Look here:

http://www.cpearson.com/excel/overtime.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

I would like a Microsoft Excel formula expert to help me please
because I need a excel formula or program that can calculate my
working hours and days for every 4 week.

I am working for company and like to calculate my own working days,
hours worked, over time and Sunday bonus.

For example let say I work these days and hours every week.

Company Payment Weekly Rate:
( Hourly Rate: Mon – Sat : £6.00

Sun - £7.00 )

So Lets say I work:

Mon (17:00pm to 00:00pm) with 30 minute break no pay for break

Sun (7:00am to 15:00 pm) with 30 minute break no pay for break.

Excel should calculate for me every 4 week by each week on the days
and hours I have giving with the payment rate above.

Plus: Overtime calculation and Tax calculate.
Pls help as this looks. I do not know how to start.please tell me how
can i start. i dont know nothing about excel.

if you have this calculation on excel or on other programs please
email on (e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top