Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Edit directly in cell Excel User tips
  • Multiple lines in cell using functions CHAR
  • Hello world! Uncategorized
  • OFFSET+MATCH Formulas - combined functions
  • Extract Address into table Formulas - combined functions
  • Walking Columns ActiveX controls
  • Searching table in 2 dimensions. Formulas - combined functions
  • Min Max vehicle Formulas - combined functions

Calculate hours between two cells

Posted on February 27, 2017 By ANmar

We needed that several times in the past
Then I found it in an old file in my laptop, thought to share it for others to help

So, when A1 has the start time, B1 has the end time
Time different in one day will be from formula

=IF(OR(A1="",B1=""),"",ABS((HOUR(A1)+MINUTE(A1)/60)-(HOUR(B1)+MINUTE(B1)/60))&" hrs")

 

I added to prevent having -ve number of hours in case start time and end times switched between A1 and B1

ABS, Basic Math, Date and Time, Hour, IF, Logical, OR, Standard functions

Post navigation

Previous Post: MATCH fumction, just a simple search
Next Post: Count how many times letter found

Related Posts

  • Progress bar in pure functions CHAR
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Schedule column Basic Math
  • Expenses calendar, FaCal Basic Math
  • Week number to Month number DATE

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • When Excel tells you to go get some life Excel User tips
  • Sorting with functions only CHOOSE
  • Middle name + 1st name Basic Math
  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • Limited Ceiling Basic Math
  • IF with AND and IF with OR AND
  • Edit directly in cell Excel User tips
  • Standard math to calculate Aspect Ratio Basic Math

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme