Excel Magic Trick 1359

Split Times Values Into 8 Equal Zones: VLOOKUP, LOOKUP or INT/HOUR?

DESCRIPTION

Learn about the basics of the VLOOKUP Function and about Time Values in Excel. Topics in this video:
(00:12) Introduction to goal of video
(01:08) Build Lookup Table with Time Values/Time Categories (8 Equal Time Zones, like One, Two, Three…)
(01:29) Learn about Excel Time Values
(03:32) Time Values and Time Number Formatting. Time Values represent the proportion of a 24 hour day.
(05:19) VLOOKUP function to get Text time categories (8 Equal Time Zones, like One, Two, Three…) for 24 hour times. Learn about the basics of how VLOOKUP works.
(08:28) How to understand Approximate Match VLOOKUP.
(09:32) VLOOKUP function to get time categories (8 Equal Time Zones, like 1, 2, 3…) for 24 hour times
(10:17) LOOKUP Function with Array Constant
(13:29) HOUR & INT function solution
(15:50) INT and *24 solution
(16:42) Summary

WORKBOOKS

Download “Excel-Magic-Trick-1341-1360.zip” Excel-Magic-Trick-1341-1360.zip – Downloaded 6993 times – 23 MB







Be the first to comment

Leave a Reply