CAPTCHA
Image CAPTCHA
Enter the characters shown in the image.
This question is for testing whether or not you are human.
  • Create new account
  • Reset your password

User account menu

Home
The Hyperlogos
Read Everything

Main navigation

  • Home
  • My Resumé
  • blog
  • Howtos
  • Pages
  • Contact
  • Search

Convert HH:mm to decimal hours in Excel

Breadcrumb

  • Home
  • User Blogs
  • User Blog
  • Convert HH:mm to decimal hours in Excel
By drink | Thu August 13, 2026

This is one of those things that should be obvious and findable anywhere right? But I had to look at five different search results! WTF!? Here is the formula:

=((LEFT(G5, SEARCH(":", G5)-1)*60)+RIGHT(G5, SEARCH(":", G5)-1))/60

Obvs change G5 to the correctly referenced cell.

excel
  • Log in or register to post comments

Footer menu

  • Contact
Powered by Drupal

Copyright © 2026 Martin Espinoza - All rights reserved