Excel Formula Help

[smartguy]

Hello all i have data in the below format.

Excel Workbook
	C
2	28:52:07
3	8:31:18
4	25:46:40
5	4:42:42
Sheet1

I Need solution like this...

Excel Workbook
	C	D
2	28:52:07	28.52
3	8:31:18	8.31
4	25:46:40	25.46
Before - Express TAT

Please help

 

[villy]

format cell into custom format h.mm

 

[ganeshpoojary05]

i think this will work:

=FLOOR(C2*24,1)&"."&MINUTE(C2)

 

[smartguy]

Great Mr.ganeshpoojary05

It will work...

Thanks...