How to add other time zones on windows 10

Just in case you live in California, but do business in Alaska, the mental math needed to keep everything on target is sometimes overwhelming. It’s a three hour time difference, but a slight miscalculation could lead to some real problems. Windows 10 has all that covered for you so no worries, Windows 10 allows you to set up multiple clocks to display times from around the world.

To access them, click on the clock in the Taskbar, as you normally would. Instead of displaying the current time, it’ll now display that and timezones from other locations you’ve set up.

1. Open Settings by clicking the Start menu and selecting it, or typing it into Cortana.

2. Click on Time & language.

3. Click the Add clocks link to set up clocks in multiple time zones.

4. Click the option to Show this clock. This will show you the original clock, the one you have set to your current location

5. Next, click the second Show this clock option, and set it to the timezone of your choice by selecting it from the drop-down menu.

6. Change the names for Clock 1 and Clock 2. (optional)

7. Click Apply at the bottom right.

8. Click OK

Read also Don't install updates if you are not tech savvy Microsoft Warns Users

Don't install updates if you are not tech savvy Microsoft Warns Users

There is still stability issues with the creators' update recently released by Microsoft, after promising users that they would have the option to postpone future updates for a limited period of time.  As the instability issues become more apparent, performing a manual installation is not recommended at the moment.

In a blog post, Microsoft’s director of program management explained that the latest update has been rolling out slowly because there are known issues that could be a problem for anyone who isn’t an advanced user. The post doesn’t go in depth on what those issues are but it appears that all the bugs haven’t been ironed out for certain devices. For instance, PCs that use a certain type of Broadcom radio were having connectivity problems with Bluetooth devices.

If you aren’t the type to manually install updates, this probably isn’t your problem. Windows 10 has automatically pushed updates to users since it debuted. The Creators Update has a lot of cool little features, but the most useful one is that it offers a simple way to pause installing updates for up to seven days. Updates are good for security but Windows has had an insidious way of suddenly deciding it’s time to install that latest patch and restart right when you’re in the middle of something important.

Microsoft is still automatically updating users this time around and if you encounter problems, you can find instructions for rolling back the update here. If you’re the cavalier type who doesn’t care about warnings and just wants to start making 3D dogs in MS Paint, you can manually download the update.



Read also Windows 10 creators update: new features: How to get it

AMD Releases New drivers for Windows 10 x64 Ryzen Chipset

For those of you who purchased the brand new AMD, Ryzen build should go to the AMD website and download the v17.10 AMD Ryzen chipset drivers. AMD says this release is intended to primarily fulfill the company's promise to include the latest AMD Ryzen Balanced power plan in the chipset driver package. The new 17.10 driver is designed specifically for systems with an AMD Ryzen CPU running Windows 10 x64. This update automatically installs and activates the AMD Ryzen Balanced as a fourth power plan.

The company went further to explain that the new AMD Ryzen Balanced power plan prevents your CPU cores from being "parked" in an idle state that could have a negative impact on gaming performance. The plan also allows your AMD Ryzen processor to more quickly raise clock speeds by reducing the timers and thresholds for P-state transitions.

The company expressed its appreciation for the feedback provided by end users on installation and usage. Moving forward, AMD promised continued support and improvements in future driver updates.

You may also be interested in AMD Launches The New Radeon Pro Duo

Ready To Use Excel Formulas : Calculating a Percent Distribution

Percent distribution is a measure of how a metric (such as total revenue) is distributed among the component parts that make up the total. As you can see in the screen shot below, the calculation is relatively simple. You divide each component part by the total. This example has a cell that contains Total revenue (cell C9). You then divide each region’s revenue by the total to get a percent distribution for each region.

 

Revenue across regions

How it works

This formula doesn’t have a lot to it. You’re simply using cell references to divide each component value by the total. The one thing to note is that the cell reference to the Total is entered as an absolute reference ($C$9). Using the dollar symbols locks the reference in place, ensuring that the cell reference pointing to Total does not adjust as you copy the formula down.

Alternative: Percent distribution without a dedicated Total cell

You don’t have to dedicate a separate cell to an actual Total value. You can simply calculate Total on the fly within the percent distribution formula. The screen shot below demonstrates how you can use the SUM function in place of a cell dedicated to holding a Total. The SUM function adds together any numbers you pass to it. Again, note the use of absolute references in the SUM function. Using absolute references ensures that the SUM range stays locked as you copy the formula down:

=C3/SUM($C$3:$C$6)

% distribution 

Read Also Ready To Use Excel Formulas :how to Calculate Percent Variance with Negative Values

Hands On Logitech G413 Mechanical Keyboard

Logitech has unveiled a new keyboard called G413. Logitech With this new keyboard is transiting to a completely new design direction.

The last gaming keyboard Logitech produced, the Logitech Pro, is essentially just a TKL version of the G810 Orion Spectrum; the G610 models are also nearly the same as the G810 Orion Spectrum, but with Cherry switches instead of Romer-G switches, and without RGB lighting. They’re all unassuming black rectangles.

Design Changes

The G413 models show that Logitech is expanding its design in terms of language to accommodate more users. First, gone is the all-black finish; instead, you can get the G413 in Carbon or Silver. Second, instead of the more traditional backplate-and-top-cover design, Logitech has followed much of the keyboard market by creating the G413 with a top plate design, with the switches mounted on top of an anodized aluminum plate.

There is also a functional change, but once you start fiddling with how your keyboard is built, you get a bit of a domino effect. For example, it has been noticed in the past that Romer-G switches on Logitech keyboards are a little noisy--there’s quite a bit of “ping” when you’re clacking away. The older design abated this somewhat, but with the switches sitting on the top plate, the noise is significantly more pronounced. To be sure we weren’t imagining things, we pulled out the G810 Orion Spectrum to compare; it’s not even close.

The other notable change that comes with the new design concerns the lighting. Logitech’s lighting system is excellent, largely due to the through-stem lighting design of the Romer-G switches that ensures all keycap legends are evenly and brightly lit. The same is true of the G413, of course, but you now also get an under-key glowing effect. Whether or not that appeals to you is a matter of preference, but note that it’s there.

Software.

The G413, predictably, comes with the Logitech Gaming Software (LGS) as well as Overwolf, which “gives in-game access to anything from PC performance statistics and monitoring to game-specific tools like LoL Wiz and CS:GO Stats.”

With LGS, you have control over a couple of lighting options the G413 affords, assign commands (including macros) to all 12 F keys, disable any key you want when you’re in Game Mode, and get a heat map of your gameplay.

\

The G413 offers 26KRO and anti-ghosting.

You may also be interested in AMD Launches The New Radeon Pro Duo

AMD Launches The New Radeon Pro Duo

AMD announced the Radeon Pro Duo graphics card targeting the professional consumer market. This new GPU is based on the fourth-generation Graphics Core Next (GCN) architecture and can perform graphic and arithmetic instructions in parallel.

The benefit of the dual-GPU Radeon Pro Duo graphics card is that designers can now use two software packages simultaneously. Professionals can take advantage of the parallel computing power of the Radeon Pro Duo graphics card to accelerate compute-intensive tasks in computer-aided design, computer-aided manufacturing, and other applications that support OpenCL.

Even if your application doesn’t support multi-GPU acceleration, this professional graphics card makes it possible to dedicate one GPU to the functions of separate applications concurrently, or to work with multiple 4K video streams in real-time. According to AMD, live content creation using the first GPU, with real-time rendering and/or ray tracing on the second GPU, is now possible.

In Ogi Brkic’s voice, general manager, professional graphics, Radeon Technologies Group, AMD, 

“Today’s professional workflows continue to increase in complexity, often demanding that creators switch between a wide variety of applications to progress their work, pausing efforts in one application while computing resources are focused on another. We designed the Radeon Pro Duo to eliminate those constraints, empowering professionals to multi-task without compromise, dedicating GPU resources where and how they need them. It’s a continuation of our promise for Radeon Pro: to provide greater choice in how professionals practice their craft, enabling superior multi-tasking, accelerated applications, and powerful solutions for advanced workloads like VR”.

The full-height single-slot Radeon Pro Duo features two Polaris 10 cores both operating at 1,243MHz with 2,304 stream processors each. Total compute power is listed at 11.45 TFLOPs. The 32GB of GDDR5 (16GB per core) operates at 7GHz for a total of 448GBps bandwidth. The Radeon Pro Duo graphics card can drive up to four 4K displays at 60Hz or one 5K or 8K display at 60Hz via the three DisplayPort 1.4 HBR3/HDR Ready outputs and one HDMI 2.0 output. Power is supplied via an 8+6-pin power connector.

You may also be interested in HP Unveils New ZBook Mobile Workstations With Updated CPUs And Graphics

HP Unveils New ZBook Mobile Workstations With Updated CPUs And Graphics

Zbook1

HP undraped updated models of its ZBook Mobile Workstations, taking them up to 7th generation Intel Core CPUs and refreshing their GPUs. This component and design refresh also permits HP to offer its first "VR-ready" mobile workstation.

Along with the hardware updates, HP has worked to extend the protection and manageability of its mobile workstation line. They support multi-factor authentication, integration with Microsoft SCCM, and currently feature HP SureStart Gen3, which HP said is the world's solely self-healing BIOS. SureStart Gen3 keeps a duplicate of the BIOS firmly encrypted on the motherboard and actively detects runtime intrusion, after which it'll restore the BIOS to its custom state. HP provides a Management Integration Kit plugin for Microsoft SCCM to facilitate remote management with its mobile workstations.

Zbook2

HP's analysis has indicated that there's an increasing focus among decision makers on show quality and resolution even in mobile devices. Its response to this trend has been to try for higher-quality displays in the entry- and middle levels of its mobile workstations, and to own its HP Dreamcolor displays obtainable for all of the high-end models.

All of the models also feature HP fast Charge Technology that purports to charge the battery from 0-50% in just 30 minutes.

In addition to the ZBook 15u G4 introduced in Jan, HP is introducing the new ZBook Studio G4, the ZBook 17 G4, the ZBook 15 G4, and the ZBook 14u G4.

Zbook 15g4 & 14u g4

The Zbook 14u and its brother the 15u are workstation-class machines offering the reliability and capability of a workstation with the mobility of an Ultrabook. both support 7th-generation Intel Core CPUs in the ultimo range (the i5-7200u and 7300u, and the i7-7500u and i7-7600u) and either integrated Intel HD 620 graphics or distinct AMD FirePro W4190M graphics. two memory slots support up to 32GB of DDR4-2133 non-ECC SDRAM SODIMMs, and the single 2.5” storage bay will support an HDD, SSD, or M.2 SSD in both SATA and Turbo Drive G2 PCIe NVMe flavors.

Zbook 17 g4

In between is the ZBook Studio G4. It's a 15.6” compact, light-weight mobile workstation that's meant to balance mobility with power. though only a half-pound heavier than the 15u, it supports quad-core mobile Intel processors similarly as mobile Xeons--specifically, the i5-7300HQ and i5-7440HQ, the i7-7700HQ and i7-7820HQ, and the E3-1535M v6 and E3-1505M v6.

zbook

When coupled with a mobile Xeon, this model also supports the use of ECC memory, and also support the use of 2,400MHz memory. you'll be able to select either Intel HD 630 graphics or a Nvidia Quadro M1200M with 4GB of dedicated GDDR5 memory on this model, and its accessorial enlargement choices embrace 2 USB Type-C ports that are absolutely capable Thunderbolt 3 ports.

Display-wise the Zbook Studio can even take up to a 4k UHD Dreamcolor display. to keep its compactness, the Studio only has an M.2 slot and not a full 2.5” drive bay. The ZBook Studio is designed to provide a balance between the lightness and compactness of the Ultrabook models and the performance of the ZBook 15 and 17. HP said the ZBook Studio model is popular with those who need to work while truly mobile.

You may also be interested in Microsofts new task manager app To-Do in beta

Microsofts new task manager app To-Do in beta

Here comes yet another task manager application and use Microsoft's Office 365 you might want to check out the new To-Do beta app.

Think of it as a Wunderlist replacement that also makes suggestions for you. It actually comes from the developers of Wunderlist and uses a sorting algorithm to determine what's important for you to do today or what you missed yesterday. A video is worth a thousand words here, and luckily Microsoft has it covered.

Always remember that this app is in beta. It looks really nice and seems to work well, but there probably will be bugs. Microsoft is quick at fixing those when it comes to its Android apps, though. And while it's from the Wunderlist folks, it's not yet a direct replacement and lacks a weekly view or the ability to star messages.

The features will likely come as Microsoft puts the finishing polish on To-Do, but even today it looks like an app a lot of people will love with the Office 365 integration and suggestion features. Check it out!


Read Also Microsoft Surface Pro 5 New Leaks

Ready To Use Excel Formulas :how to Calculate Percent Variance with Negative Values

In the previous post, “how to Calculate Percent Variance,” you discovered how to calculate a percent variance. That formula works beautifully in most cases. However, when the benchmark value is a negative value, the formula breaks down.

For example, imagine that you’re starting a business and expect to take a loss the first year. So you give yourself a budget of negative $10,000. Now imagine that after your first year, you actually made money, earning $12,000. Calculating the percent variance between your actual revenue and budgeted revenue would give you -220%. You can try it on a calculator. 12,000 minus -10,000 divided by -10,000 equals -220%.

How can you say that your percent variance is -220% when you clearly made money? Well, the problem is that when your benchmark value is a negative number, the math inverts the results, causing numbers to look awkward. 

This is a real problem in the corporate world where budgets can often be negative values.

The fix is to leverage the ABS function to negate the negative benchmark value:

=(C4-B4)/ABS(B4)

The screenshot below uses this formula in cell E4, illustrating the different results you get when

using the standard percent variance formula and the improved percent variance formula.

 Using the ABS function 

How it works

Excel’s ABS function returns the absolute value for any number you pass to it.

Entering =ABS(-100) into cell A1 would return 100. 

The ABS function essentially makes any number a non-negative number. Using ABS in this formula negates the effect of the negative benchmark (the negative 10,000 budget in the example) and returns the correct percent variance.

Read Also Ready To Use Excel Formulas: how to Calculate Percent Variance

Samsung Galaxy S8 display has a reddish tint

reddish tint

The Galaxy S8 will be available to the public this week, some users who have already received their units and discovered the first major issue of the phone, a problem that affects the most important feature of Samsung’s new flagship handset.

According to a report from The Korea Herald, the Galaxy S8’s display has a reddish tint. The Infinity display of the Galaxy S8 is one of its best features, one that’s currently unavailable on other devices. Sure, the LG G6 also has a high-resolution edge-to-edge display, but Samsung went for a curved OLED display rather than a flat LCD screen. 

The Galaxy S8’s screen is currently graded as the best screen out there by some experts, and the iPhone 8 is expected to also feature an OLED screen made by Samsung.

The Herald explains that the reddish tint issue might be caused by the color balance of the screen. However, customers who already received the handset say the reddish screen did not improve after correcting the color display settings.

“The reddish tint may be caused by a color balance problem after Samsung used deep red AMOLED to strengthen the red,” an unnamed industry watcher said.

Samsung developed deep red OLEDs to prevent any color issues with the phone. The report says the OLED panel in the Galaxy S8 uses two subpixels, including red-green and blue-green.

“It is not a quality problem, and it can be adjusted with the phone itself. If the color still appears to be reddish, customers can change it at the service center,” Samsung said.

The Galaxy S8 isn’t widely available for the time being, but plenty of people already received test units ahead of the phone’s launch. A bunch of YouTubers have gone ahead and put the phone through a variety of tests, but they have not signaled out this particular issue with the phone.

It’s unclear at this time how widespread the red tint issue is, and whether it can be corrected via software. That said, it’s not unexpected to see some issues with new phones, and it’s likely Samsung will fix any problems. After all, the last thing Samsung wants is having to deal with any quality issues with the handset.

Read also Samsung Launches S8 with an amazing design and Bixby AI assistant

Whatsapp updates 5 new features

Facebook-owned WhatsApp has been continuously bringing updates to its platform to make its mobile app better for the users. Every update includes improvements, bug fixes and new features. Thanks to online reports rumours we have listed few features that can be seen with the coming updates.

Here are 5 new features that can be seen in the future:

Live location:

WhatsApp is allegedly working on Apple’s ‘Find Friends’ feature. The feature was recently introduced by both Facebook and Google. According to an online report, the WhatsApp beta for Android v2.17.150 contains mention of the feature, however, it is disabled by default.

 Recall message:

According to @WABetaInfo, the firm is testing the feature in a new beta release of WhatsApp Web version 0.2.4077, which will allow users to ‘unsend’ sent messages within a five-minute time frame.

New shortcuts:

WhatsApp is also testing new shortcuts for formatting text on a beta version of the app on Android. In the beta version, the app displays a full range of formatting options—Bold, italic, strikethrough, when an excerpt of text is selected.

Person-to-person payment:

According to Mashable India, WhatsApp is in talks with the Indian government to add support for UPI, which allows access to multiple bank accounts into a single mobile app to make digital payments. At present, over 200 million people use WhatsApp across the country.

Change numbers:

WhatsApp may soon allow users to change their contact number and also notifies user’s contacts about the change without losing chats and group data. The feature also provides users with three options – share the new number with all their contacts or choose to share the new number only with those they have chats with. They can also choose not to pass out their new number with anyone. The new feature will solve several problems for users who lose out on chat when they change their numbers.

You may also be interested in 2 deadly WhatsApp virus that can hack phone details: Users beware!

HTC U with Snapdragon 835, Edge Sense, Android Nougat to launch this April

HTC U Spec

HTC is preparing to strengthen its U series, with another smartphone, that is dubbed to be the HTC U, also called the HTC Ocean. The smartphone maker announced two devices under same U series earlier this year - HTC U ultra and U-Play which with no doubt, looks absolutely stunning.

If the rumours are to be trusted, the future HTC U is going to a bit different than the previous U series devices, with metallic body structure, with all state of the art technology packed together. we with confidence say this, when a well-known leakster, Evan Blass posted the same on his twitter handle.

 

evleaks tweet

Blass tweets that, HTC U with a codename Ocean is anticipated to come packed with Qualcomm's latest processor, snapdragon 835 SoC. 

This clearly indicates that the smartphone manufacturer is all set to throw a tough battle with the upcoming Xiaomi Mi 6, OnePlus 5 and also the already launched Samsung Galaxy S8 and S8+.

Along with mentioning the specifications, Blass nearly leaked image renders of the to-be-announced HTC U. the picture of the smartphone shows screen-to-body ratio style on board along with a physical home screen button at the front. this is often not it. 

The HTC U is also expected to come with Edge Sense, which can allow users to perform several activities simply by tapping on the metallic frame of the smartphone.

HTC U leaks

As per a report by VentureBeat explaining Edge Sense mentions, "Edge Sense - the frame-embedded sensors enable the user to regulate numerous, customizable actions with gestures like compression or swiping on its left and right sides."

HTC U

Further, in terms of specifications, the HTC U, better referred to as the HTC Ocean is expected to run on the newest android 7.1.1 Nougat. 

The smartphone, as Blass predicts, which is often accurate will come full of a five.5-inch WQHD show with 2560x1440 element resolution. The HTC U can more be battery-powered by Qualcomm's latest processor - flower 835 chipsets.

You may also be interested in Honour 8 Pro: Huawei's Latest Killer Flagship