payroll questions

[bootscootingab]

i need to know the formula to calculate the following:

an employee comes to work of monday at 7:00 am

they clock out for lunch at 11:12 am

they return from lunch at 12:18 pm (12:00 being noon)

they clock out at 4.03 pm to go home for the day.

I need to calculate how many hours and minutes this employee worked o
this monday and them show me the time in decimals.


------------------------------------------------

i also need to know how to calculate the amount of pay for the
following employee:

currently paid an hourly wage of $11.00 per hour for 40 hours per wee
paid semi-monthly. what would the semi-monthly salary be?

can someone out there help me.

thank you in advance,

bootscootinga

 

[Dave Hawley]

Hi bootscootingab

=(ClockOut-ClockIn)-(LunchIn-LunchOut)

Format as required.

To covert to a decimal;

=(ClockOut-ClockIn)-(LunchIn-LunchOut)*24

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Norman Harker]

Hi!

To convert to decimal hours, Dave meant:

=((ClockOut-ClockIn)-(LunchIn-LunchOut))*24

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Arvi Laanemets]

Hi Dave

I'm afraid this must be
=(ClockOut-ClockIn)-(LunchOut-LunchIn)
and
=((ClockOut-ClockIn)-(LunchOut-LunchIn))*24

Otherwise you get 10-hour workday for employee, working at 08:00 to 17:00
and having a hour for lunch.

 

[Dave Hawley]

DOH! Thanks guys. I must start testing before posting........nah!

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Norman Harker]

Hi Dave!

Re:
"I must start testing before posting........nah!"

She'll be right!
--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Dave Hawley]

Hiya Norman

RE: She'll be right!

That's the Aussie way )

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***