Converting xx:xx to regular number format

[yxz152830]

Maesters,
I have a field with 00:35 in it. I tried converting it to number format in Format Cells but it won't change regardless. The only thing I could do was to 1- (1- referenced cell) to convert it to number format. I'm not even sure if the conversion is accurate. Thanks in advance!

 

[Toadstool]

Hi yxz152830,

Excel holds time as a fraction of a day so you can use VALUE to convert to its internal representation. You can multiply by 1440 to get minutes (60 minutes x 24 hours a day) or multiply by 24 to get decimal hours.

yxz152830.xlsx
	A	B	C	D	E
1	Original		VALUE	Minutes	Decimal Hours
2	03:05		0.128472	185	3.083333333
Sheet1

Cell Formulas
Range	Formula
C2	C2	=VALUE(A2)
D2	D2	=VALUE(A2)*1440
E2	E2	=VALUE(A2)*24