Weekends Search Results

How To: Make date & time calculations (sans weekends) in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 533rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to calculate the difference between start date/time & end date/time excluding holidays and weekends. This is accomplished with recourse to Excel's NETWORKINGDAYS and MOD functions.

How To: Conditionally format dates & weekends in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply custom number formatting as well as how to conditionally format dates and weekends using a TRUE FALSE formula with the AND and WEEKDAY functions.

How To: Make an Excel Gantt chart that highlights workdays

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 327th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt Chart that will include highlight the workdays one color and weekends and holidays another color.

How To: Sell stuff at a flea market

Selling stuff at the local flea market sounds easy enough, but it isn't anything like having a yard sale. There's a lot more to it that just getting rid of your junk, and the biggest things are being licensed and having a sales tax number. Flea market vendor may not be your first career choice but, like many, you may find it’s a lucrative full-time job or a profitable and fun sideline.

How To: Sew a digital display decal for your car

This film explains how to sew a digital display for use as a car accessory. It was created by our very own Steve Spencer as part of a competition that Scion held called "Craft My Ride." Steve has been working on this during nights and weekends and its pretty fun stuff. He used http://www.sensables.com authoring tools (beta version) to design the animation.

How To: Format dates with the WEEKDAY function in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 534th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR and WEEKDAY functions to create a logical true/false formula that will automatically apply formatting to dates that are either weekends or holidays.

How To: Count dates with an array formula in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 142nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a complex array formula that counts weekends between two dates with the SUM, IF WEEKDAY, ROW and INDIRECT functions.

How To: Exercise to get in shape for mountaineering

Ali Alami with Fit Climb demonstrates how to get in shape for mountaineering. You can do these exercises in a park or at home. Your core and lower body are important in mountaineering. First, find a wet, wood bench that is four to six inches off of the ground. Do step ups to work your quadriceps and glutes. Balance briefly on one leg and then bring the other leg up. You can also do side steps. Step downs help you get you used to gravity. Calf raises are also helpful. To strengthen your core u...

How To: Calculate days worked on a project in Microsoft Excel

Calculate the amount of days worked on a given project within MS Excel! Do you maintain work schedules for your projects? Are you manually subtracting weekends and holidays from your project estimates? There's a better way. And this digital spreadsheet tutorial will show you how. For detailed, step-by-step overview on how to easily and efficiently maintain a count hours of labor, watch this free video software tutorial.

How To: Organize your garage

This video demonstrates the process for organizing your garage. The video interviews an employee from The Container Store which offers organizational products for every room in the house. They stress that organizing a garage is not a one day project. The Container Store recommends taking three full weekends to organize a garage, start out by focusing on one wall at a time. Labeling is a big part of The Container Store's organizational plan, everything has its own place with a label. The label...

How To: Prevent razor burn and ingrown hairs when shaving

In this video, which is another installment of Masc Minute, we learn about razor burns, and how to prevent and treat razor burns. One thing is that you don't want to be using a dull razor. As soon as your razor is done, throw it out, because that will definitely irritate your skin. You also want to use a good shaving cream that will protect your skin. But something you can do to help treat razor burns specifically is using a post-shave repair product. The product recommended in this video is ...

How To: Create a Basic Attendance Sheet in Excel

If you're a teacher in any type of school, whether it's high school, college, or middle school, it's imperative that you keep an attendance sheet. The paper and pen route can get pretty messy, and very disorganized, and that's where Microsoft Excel comes in. With this software, you can create a simple yet functional attendance sheet to keep track of your students.

How To: Tie the Compara Spinner for fly fishing

Enjoy fly fishing on the weekends? Take a look at this instructional video and learn how to tie the "Compara Spinner", TPO's fly of the month for May 2008. This dry fly is an Isonychia imitation and the dubbing used in this tutorial makes it super effective. Fool a big one up top on your next trip to the Delaware.

How To: Put Your Samsung Galaxy Note 2 in Deep Sleep Mode to Save Battery Life

Newer smartphones are more power hungry than ever before, and the Samsung Galaxy Note 2 has a mighty appetite for amps that only Jenny Craig could possibly curb. On average, your Note 2 (or other Android device) lasts for what, a day, maybe two days before dying. Mine barely lasts 8 hours! This is thanks to all of the apps running in the background of your phone, even when you're not using them, eating through all of your CPU, leaving nothing but crumbs.

How To: Set Different Downtime Schedules on Your iPhone for Each Day of the Week

When Apple released its Downtime feature in iOS 12, it gave us an easy way to control how much time we spend on our iPhones — but it wasn't perfect. When setting Downtime, you' were forced to use the same time schedule for every day of the week, so your weekdays and weekends had the same restrictions. Apple fixed that issue in iOS 12.2 and later, so lockout periods can be more customized.

How To: 5 Fruits to Throw on the Grill This Summer

The grill isn't just a place for burgers, dogs, and corn anymore. Fresh fruit has made its way into barbecue territory, with results so good, you'll think twice about settling for fruit salad. While some fruits are common enough on the grill (like pineapple), these six are more off the beaten trail: peaches, watermelon, strawberries, mango, and pears.

How To: Make Preserved Lemons

One of the great joys of cooking is taking the most basic of foods and preparing them in new and exciting ways. About two years ago, my wife opened my eyes to a delicious staple of Indian and Moroccan cuisine that is made in a very elementary way, the preserved lemon.

How To: Score Great Wine at Bargain Prices

Whether you're a seasoned wine drinker or just beginning to explore the wondrous world of fermented grapes, finding fantastic wine on a budget isn't as difficult as one may think. With these 8 tips, you'll see how and why you need not shell out $45 to get a great-tasting, high-quality bottle of wine without settling for vino.

Prev Page