RSS Amplifier

The Hyperlogos - Read Everything · Aug 14, 2026

Convert HH:mm to decimal hours in Excel

0
Sign in to vote or save

By drink | Thu August 13, 2026 · hyperlogos.org

Home

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.

Tags

Read the original on hyperlogos.org

Comments

Nothing yet. Say the first thing.

    Sign in to join the conversation.