Hours Worked From Time Clock Log

**Billy Spivy** · 03-16-2018, 04:44 PM

Hello,

Does anyone know how to get the Daily Hours from the 'Time Clock Log' and put the result in 'Payroll' D5?

Thanks,
Billy

**Keebellah** · 03-16-2018, 07:12 PM

Hi Billy,
welcome to the forum,
First thing I noticed is that paid time in column K adds up 51.13 while it should read 29.36 because this person is not clocked out yet
the formula should include the cehck to see if this person has clocked out

Please Login or Register  to view this content.

You Payroll question, I see a long formula that does something but a simple match and index of the person's ID will retrieve the cell in the Time Clock Log and the offset(0,8) will show the value above the daily hours.

I'm no good with INDEX and MATCH formulas but I'm sure you can look this up but that would be my approach

Hours Worked From Time Clock Log

LinkBack

Thread Tools

Rate This Thread

Display

Hours Worked From Time Clock Log

Re: Hours Worked From Time Clock Log

Thread Information

Users Browsing this Thread

Similar Threads

Calculating Hours Worked Past Midnight - Without no time entries equating to 24 hours.

[SOLVED] Calculate total time worked from ClockIn and Clock Out Info.

[SOLVED] how to calculate hours worked using 24hr clock

Calculate hours worked minus 30 min break if hours worked are greater than 4.5 hours

[SOLVED] Punch-Time Data. Calculating # of hours worked and # of hours worked alone per shift.

Calculating basic hours worked, between a time range and premium hours worked

Excel 2007 : Calculating basic hours worked, between a time range and premium hours worked

Bookmarks

Bookmarks

Posting Permissions