Skip to main content

Featured

Golden Rules Of Investment

12 GOLDEN RULES OF INVESTMENT Live by these 12 rules and let your money grow!  1) The past is irrelevant –   Do not rely on past performances and build castles in the air. Invest for tomorrow and live for today.  2) Opinions can hurt. Don’t ask too many people –   just don’t!! To each, his own. What works for someone else, may not work for you and vice-versa. Your investment plan should be as unique as the back of your hand. More importantly, it must suit you best.  3) Everyone’s journey is different. Understand yours. –   Do not invest if you’re not clear on the purpose. Do not draw parallels with other investors. Your need for investing, risk appetite, and nature of investments is of utmost importance. You need to understand what you are doing.  4) Don’t allow your ego to engage with professional advice –   Trust your financial advisor! Google can give you lots of information but your advisor will tell you what’s best for you. Listen and then act!  5) Overthinking will never allow
Post a Comment
Read more
Labels

Time function in excel

 Time Function

Excel can give you the current time, based on your computer's regional settings. You can also add and subtract times. For instance, you might need to keep track of how many hours an employee worked each week, and calculate their pay and overtime.

1. In cell D28, enter =NOW0, which will give the current time and update each time Excel calculates. If you need to change the Time format, you can go to Ctrl+1 > Number > Time > Select the format you want.

2. Add up hours between times - In cell D36 we've entered =(D35-D32)(D34-D33) *24, which calculates someone's start and end times, then subtracts the time they took for lunch. The *24 at the end of the formula converts the fractional portion of the day that Excel sees into hours. You'll need to format the cell as a Number though. To do that, go to Home > Format > Cells (Ctrl+1) > Number > Number > 2 decimals.

3.If this formula could talk, it would say, "Take the Time Out and subtract it from the Time In, then subtract the Lunch Out/ln Times, then multiply those by 24 to convert Excel's fractional time to hours", or =(Time In Time Out)-(Lunch In - Lunch Out)*24.



Labels:

Comments

Post a Comment

Popular Posts