I'm trying to create a spreadsheet to track misc. work related stuff.
As part of the sheet, I would like to calculate break information Like:
What time I have to be back at my desk based on what time I leave for break, and total hours worked w/o counting my breaks.
So, say I clock out for break @ 5:30pm. I would like to input what time I leave for break in cell B, and have C
show what time I would need to return.
Ex: 5:30pm + 15mins, means I need to be back @ 5:45pm.
My breaks are 15 minutes, and my lunch is 1 hour. This is
kind of how I want it set up:
1 ___________________Break____Return @
2 Start_____________3:30 PM_____n/a
3 1st break (15min)___5:30PM___5:45PM
4 lunch (1hr)_________7:30PM___8:00PM
5 2nd break (15min)__10:30PM__10:45PM
6 End of shift:_______12:00AM_____n/a
7 Total Hours:_______ 8 Hours
Is this possible?
I would need formulas for cells C3, C4, and C5 to show when to be back.
...and for B7, which I would like to calculate my total hours that I worked, minus my breaks.
I know I can
calculate what time I need to return in my head, but I would like to track everything in this sheet, and would like it to
calculate when I should return vs actually figuring it, and then just typing it into the cell.
I've been trying to
figure this out for a few hours, doing various searches, looking at premade templates, and still can't figure it out.
Any help would be GREATLY appreciated.
(I had to put "___" to keep everything aligned as I post it here.
It scrunched it together where I originally put spaces. I'm using "___" to try to make this post clear as to how I
plan on setting this up. I don't plan on putting "___" in my sheet.)