Join Dennis Taylor for an in-depth discussion in this video Convert between time units: Day/hour, year/day, etc., part of Excel 2016: Cleaning Up Your Data.
- [Instructor] When you're getting data from other sources…and you've got entries like we see on this worksheet…called convert dates times, sometimes you run into…tricky issues when working with days and trying to…convert them into hours and in some cases you'll have…data in both forms but moving the data back and forth…between different calculations here gets very tricky…sometimes with time.…The key number to remember very often is 24, there…are 24 hours in the day of course and that's the calculation…we need to be thinking about.…The entries in column A are days worked, you'd rather…see hours worked, well we could multiply this by eight,…there are eight hours a day, let's say in most environments…so two and a half days times eight, we're going to get…20 here, but we might want to see it displayed as an hour.…
Let's first of all just begin multiplying this by eight.…No surprises there we get 20, but can we convert…this into a time?…If we go to format cells, and you can get quickly there…either by right clicking and choosing format cells…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Moving and inserting rows and columns of data with a simple drag
- Replacing data at the character level
- Converting dates with text functions
- Converting text data to values
- Using the CONCAT and TEXTJOIN functions to combine data
- Splitting data into columns via the Text to Columns feature
- Using Flash Fill for faster combining and splitting
- Checking and correcting spelling mistakes