payroll questions

  • Thread starter Thread starter bootscootingab
  • Start date Start date
B

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
 
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.
 
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.
 
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.
 
Back
Top