Time issues

Grymm

New Member
Joined
Aug 12, 2016
Messages
4
Hello I have a question I'm having problems finding a solution for.
I have a time sheet which someone would complete as 07:00 in, 12:00 out for lunch, 13:00 Back from Lunch, 17:00 finish.
What Im trying to do is to break down what the person has put in so it shows at what points during the day they are in on an hourly breakdown sheet, as in they are in at 07:00, in at 08:00 etc but out at 12:00, in at 13:00, in at 14:00 etc
Ive looked all over but to be honest Ive been having problems trying to describe what I'm after when I'm putting it into a search engine.
Can anyone help with this please :confused:

Thanks in advance
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
give them four columns
start break start break finish finish, then you work the hours between start and finish and extract the break start finish

]
]]
 

Forum statistics

Threads
1,136,318
Messages
5,675,057
Members
419,548
Latest member
wfarzand

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top