Forum

Notifications
Clear all

Timesheet Calculation Formatting

3 Posts
3 Users
0 Reactions
195 Views
(@julihjohnson)
Posts: 1
New Member
Topic starter
 

I need to create new timesheets and am running into a wall when trying to figure out a formula.

What needs to be tracked is time worked (as decimal) and meal break (as decimal) where staff enters:

The cells staff fill in are: Time in - Time out (meal) - Time in (meal) - Time out --

The cells that populate are: Hours worked -- Meal break

I am able to get this done using this formula for hours worked: =SUM(IF(C5<B5,C5+1,C5)-B5,IF(E5<D5,E5+1,E5)-D5)*24

And this formula for meal break: =MOD(D5-C5,1)*24

What I can't figure out is what to do if people come in and leave and DON'T take a meal break. Can anyone help?

 

Thank you,

Juliana

 
Posted : 28/09/2018 7:30 pm
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Juliana

Please attach what you have done so far for us to understand better your needs.

Sunny

 
Posted : 29/09/2018 12:43 am
Anders Sehlstedt
(@sehlsan)
Posts: 970
Prominent Member
 

Hi Juliana,

Do check these blog posts, I am pretty sure they will give you the guidance needed.

https://www.myonlinetraininghub.com/excel-time-calculation-tricks
https://www.myonlinetraininghub.com/calculating-time-in-excel
https://www.myonlinetraininghub.com/excel-networkdays-intl-function

Br,
Anders

 
Posted : 01/10/2018 3:07 pm
Share: