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

Related Articles

DESCRIPTION See how to Get the Total for each employee when the Employee Name column has many empty cells and the “TOTAL” is in a row without an employee name. See five methods: (00:13) Introduction [Read More >>>]

DESCRIPTION What if you are not allowed to have a helper columns to lookup Price and Region with VLOOKUP? And you need to calculate Total Revenue by Region? This video shows how to create a [Read More >>>]

DESCRIPTION See how to create a report that require that we find the MIN and MAX Alphanumeric Academic Quarters for each Student ID. See eight different methods including: 1) VLOOKUP, 2) MIN & IF Array [Read More >>>]