But there is a problem when we must reference another sheet in a secondary one. And if it has a bookmark link it gets more confusing. Don't you think so?
I am having a hard time, my standard week hours is 50, and when i enter the custom format [h]:mm and the formula =time(50,0,0) it gives me 2:00. how can i get this to say 50 hours is my standard work week
I'm trying to create a time series that starts at minus 20 minutes and each descending cell is ahead by 30 seconds 😅😅😅 so -0:20:00, -0:19:30, -0:19:00 etc until like. +1:19:30. This has been such a headache!! I need to do increments by seconds, but starting "negative time" ="Cell"+30*(1/24/60/60) did not work for me, how is the first cell formatted?
Thank you from the bottom of my heart for all the invaluable lessons you shared on Excel. Your channel was my go-to guide for school projects, and your teaching style made complex concepts so much easier to understand. It's with a heavy heart that I learned of your passing. You were not just a teacher on RU-vid, but a mentor who made a lasting impact on my learning experience. Your legacy will live on through the knowledge you shared. Rest in peace, and thank you for everything. 💔🙏
Great video. I would like to throw a wrinkle in there. For reasons too long to explain here I need to convert the OT hours to regular hours and then calculate pay. Excel is giving me problems when doing this. For example a worker worked 65.hours at 9.25 and 7 hours of OT at 12.38 so his pay should be 687.91. NOW, if I convert the OT hours (7*1.5=10.5) and I add them to the regular hours 65 + 10.5 = 75.5 * 9.25 I get 698.38
Thank you, this video changed my life. My marriage has never been better, my children started respecting me, and I became independently wealthy and no longer have to work. I also learned how to freeze the first column on an excel spreadsheet.