converting time in a customer format

Shades228

New Member
Joined
Dec 11, 2005
Messages
12
I'm trying to convert a custom field of [h]:mm to a decimal format.

I've already tried to use =(HOUR(A1)+(MINUTE(A1)/60) but it will not convert it correctly. I've also attempted using an intiger but that is not working as well.
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
If you mean, say having a time of 8:15 and you want 8.25 then

=A1*24

Format cell as General or Number
 

Watch MrExcel Video

Forum statistics

Threads
1,118,030
Messages
5,569,757
Members
412,289
Latest member
Kingchaos64
Top