Join Dennis Taylor for an in-depth discussion in this video Converting between time units, part of Cleaning Up Your Excel 2010 Data.
If you've got data that includes hours or days entered with decimals, you might…need to convert these into either day or hour entries so that the values can be…used in a computational way.…There are a few standard formula techniques that provide these solutions.…Look at the data in Column A. 8.25 hours.…Now if we actually want to convert this into a time, typically we'd need, at least…for a while, a temporary column or cells to the right.…And what we need to do here is take this value and divide it by 24.…
The unit of measure in the Date/Time system in Excel is one equals a day.…So we end up with this. That's actually 0.34, or you could say 34% of a day, but…let's display this as a time.…Now we could right-click and press Format Cells, but a nice keystroke shortcut,…if you'd like to use it, is Ctrl+Shift+@.…The problem with that though is we see in AM on there, and that's not really wrong,…but I think in this context we wouldn't want to use Ctrl+Shift+#.…
What we really need here, what would be better, would be to right-click and go…
- Moving or inserting rows and columns of data with a simple drag
- Using Text to Columns
- Harnessing the Find and Replace command to replace data at the character level
- Dealing with special characters and wildcards during search
- Converting dates with text functions
- Converting text data to values/numbers
- Checking and correcting spelling mistakes
- Splitting data into multiple columns via the Text to Columns feature
- Combining data from different columns via concatenation
Skill Level Intermediate
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.