Terrific summary of Excel time-math, Mike. Working with time calculations troubles lots of people, especially when the clock ticks over as it does for night-shifts.
@excelisfun
6 жыл бұрын
Thanks for the terrific comment and support : ) Yes, Night Shift - that is two videos ahead : )
@alexxgalindo8557
2 жыл бұрын
Amazing class as always sir
@excelisfun
2 жыл бұрын
Glad this helps!!!
@OakleyTurvey
6 жыл бұрын
Awesome as ever. Fun times!...and very useful for anyone working with payrolls and timesheets.
@excelisfun
6 жыл бұрын
Yes, Time Number Formatting (and what is underneath) and calculating hours worked is one of those Excel things that baffles almost all Excel users in the world... Thanks for your support, Oakley!!!!
@pmsocho
6 жыл бұрын
Great video! Thumbs up!
@excelisfun
6 жыл бұрын
Thanks, teammate : ) : )
@nsanch0181
6 жыл бұрын
Thanks Mike!
@excelisfun
6 жыл бұрын
You are welcome, Nick!
@ismailismaili0071
6 жыл бұрын
you are really really awesome all the point i need to know i got them in the video and that is what really great about you i always think that it seems like you know me or you know what i need from the topics u shot a video on thank you Mr. Mike
@excelisfun
6 жыл бұрын
Yes, after 20 years of teaching Excel, it is my job to remember all the questions that I have received on a topic and then try and make a new lesson that answers all the past question, in the right order, during the video : )
@simoiyahector-morales9521
6 жыл бұрын
excellent video and explanation as always Sir Mike
@excelisfun
6 жыл бұрын
You are welcome! Tahnks for your support : )
@SyedMuzammilMahasanShahi
6 жыл бұрын
Thanks Mike for this Amazing video
@excelisfun
6 жыл бұрын
You are welcome for the amazing video!!! Thanks for your amazing support : )
@alialbayati9368
6 жыл бұрын
Amazing as usual Mike. Thanks.
@excelisfun
6 жыл бұрын
Glad you are amazed : ) Thanks for for the support with your comment, Thumbs Up and Sub, Ali : )
@krn14242
6 жыл бұрын
Thanks Mike.
@excelisfun
6 жыл бұрын
You are welcome, WRH!!!!
@LearnAccessByCrystal
6 жыл бұрын
great explanation, thank you Mike
@excelisfun
6 жыл бұрын
Thanks for watching, Crystal : )
@diazmiramontes
6 жыл бұрын
I needed this. Thank you!
@excelisfun
6 жыл бұрын
You are welocme! Thanks for the support with your comment, Thumbs Up and Sub : )
@Clifffffffffford
6 жыл бұрын
Thanks !
@excelisfun
6 жыл бұрын
You are welcome!
@aamir6282
6 жыл бұрын
very very nice tricks you giving i like it
@excelisfun
6 жыл бұрын
Glad you like the tricks! Thanks for your support!
@unisoft5956
6 жыл бұрын
Superb janaab
@excelisfun
6 жыл бұрын
Glad you like it! Thanks for for the support with your comment, Thumbs Up and Sub : )
@yuvrajspatil5475
6 жыл бұрын
nice videos Mike..... hours work should be hh:mm format so people can understand how many hours & how minutes staff has worked..
@excelisfun
6 жыл бұрын
Thank you, sir!
@geraldsardua
6 жыл бұрын
Thanks Mike :)
@excelisfun
6 жыл бұрын
You are welcome!
@mohamedchakroun4973
6 жыл бұрын
Thumbs up
@excelisfun
6 жыл бұрын
Thanks, Mohamed!!!! : )
@myunghayes5639
6 жыл бұрын
Hi Mike, I can't download this Excel file(Math 29). It shows "PAGE NOT Found". Is this link error? 😭
@myunghayes5639
6 жыл бұрын
I have just download this file from your website. Thanks!
@رقيةوقران
2 жыл бұрын
PLEASE HELP ME I NEED IT NOW
@simfinso858
6 жыл бұрын
Nice video
@excelisfun
6 жыл бұрын
Glad you like it! Thanks for the support : )
@simfinso858
6 жыл бұрын
ExcelIsFun Tip for Your 11th std Accounting students For ledger posting i know this comment is not Anyway releted to above video but i just feel like telling Your students this might make any students life easier ..so tip is just ask students to Write " Receiver " on Debit side of personal A/c "Giver" side on credit side & Same for Real A/cs Debit side write "Incoming " & "Outgoing " on credit side & " Expenses" on Debit Side of Ledger A/c & Income on credit side of the Nominal A/c on Top of Each Ledger when they are making first time Ledger posting in their life with pen & paper .once they understand Ledger posting by Hand on pen& paper ,They have many Accounting softwares for their future life .
@GencoupeVan
6 жыл бұрын
Is there anyway to type in the time and use the formulas without typing in the colon? E.g. 800 for 8am instead of 8:00
@excelisfun
6 жыл бұрын
Not that I know of. You might be able be able to do it with VBA code, but i do not know how to do it...
@shubhamkanauji7261
4 жыл бұрын
When I'm trying to download excel file it is showing error " The page you requested is not available " 🥺🥺🥺
@رقيةوقران
2 жыл бұрын
ME TO I CAN'T DOWNLOAD IT
@rraushan2088
6 жыл бұрын
Hi can you help me I want if value is anywhere in sheet1 and when I put the same value in sheet2 any cell I get that value address in front of that....help me if it’s possible with vba code pls send me vba fot this....
@excelisfun
6 жыл бұрын
I do not know how to do that at all... You can post question to this great Excel Question site: mrexcel.com/forum
@رقيةوقران
2 жыл бұрын
THAAAAAAAAAAAAANX MIIIIKE BUT THE LINK OF Excel File DOESN'T WORKING
@excelisfun
2 жыл бұрын
Try it now.
@رقيةوقران
2 жыл бұрын
@@excelisfun Thaaaanx you are the best prof yes it's working now
Пікірлер: 56