Get Digital Help
  • Home
  • Templates
  • Products
  • Functions
  • Archive
  • Contact
    • Contact me
  • About Me
    • About me
    • Blogs I read

    Function Reference

    Formulas

    Charts

    Conditional Formatting

    Excel Tables

    Pivot Tables

    VBA Knowledge Base

    Macros

    User Defined Functions

    Videos

    Advanced Excel Course



    Most used functions

    COUNTIF function

    INDEX function

    IF function

    SUM function

    SUMIFS function

    SUMPRODUCT function

    VLOOKUP function




Archive for HOUR function


How to use the HOUR function

Returns an integer representing the hour of an Excel time value. The returning number is ranging from 0 (12:00 A.M.) […]

Days between two dates

The DATEDIF function in cell E3 allows you to calculate days between two dates.

How to AVERAGE time

Column C contains both date and time, to calculate the average of only time we need to extract the hours, minutes […]

Use MEDIAN function to calculate overlapping ranges

I found an old post that I think is interesting to write about today. Think of two overlapping ranges, it may be dates, […]

      Formula categories

      Count

      Dates

      Extract

      Index and Match

      Logic

      Lookups

      String manipulation

      Sum

      Time

      Vlookup

  • Welcome! I am Oscar and here to help you! Feel free to comment and ask excel questions.
    Don´t forget to add my RSS feed and subscribe to new blog articles by email.
  • Sign up for free blog updates

     
  • Search website

sponsored