Good Morning Phillips, here's my dilema. am creating a worksheet that auto populates employee breaks upon entering start and hours worked. Shifts >=10 will get 2 breaks and lunch every 2.5 hrs. <=5 hrs worked will get 1 break only every 2 hrs. shifts of 5.5 to 8 hrs get 2 breaks 1 lunch every 2 hrs. Now, I have 20 employees of which I may have 4 starting at the same time, so I will schedule them in an increment of 15mins. Hope you can guide.
splendid ... a true teacher of excel
Careegar 3 weeks ago
amazing just what i was searching for thx :))
mariam88able 1 month ago in playlist Excel 2007 key
Superb Teacher !!! I'm finally getting the hang of it........BRAVO !!!
CENTAURSARATOGA 8 months ago
Good Morning Phillips, here's my dilema. am creating a worksheet that auto populates employee breaks upon entering start and hours worked. Shifts >=10 will get 2 breaks and lunch every 2.5 hrs. <=5 hrs worked will get 1 break only every 2 hrs. shifts of 5.5 to 8 hrs get 2 breaks 1 lunch every 2 hrs. Now, I have 20 employees of which I may have 4 starting at the same time, so I will schedule them in an increment of 15mins. Hope you can guide.
chowman007 8 months ago
Goshh! You are a life saver!!! ;)
shiploo2010 10 months ago
wow, In this light, you're stunning
mortalkombatmm 11 months ago
When using the right mouse key to lock the figures- can you reverse the function so that you can edit the figures??
Otherwise brilliant videos great help with SAGE level 2 Excel
pen567tinio 1 year ago
i have problem with my company comsion
if stock rate is 1 to 50 then commision (0.05) , more then 50 (0.10) more 100 (0.15) 150(0.20) 200 (0.25)
proble acourd in if condiotion there is only two condition but i faced more then 5 how i apply formula please help
azeesulaman 1 year ago
Excellent tutorials with superb example
Thanks so much for posting it
keep up good work
God bless you :-)
tirathmistry 1 year ago
i learned stuff even from the set up - what program are you using to record your screen?
davidnee 1 year ago