HOW TO CALCULATE IN HOURS

[Vinay kumar]

IF I HAVE this type data --------2 Days:14 Hours:32 Mins-----

 

[bosco_yip]

Try...........

1] A1, enter: 2 Days:14 Hours:32 Mins

2] B1, enter formula :

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1," Days:","/1/1900 ")," Hours","")," Mins","")*24

Regards
Bosco

 

[Vinay kumar]

convert in hour???????

 

[vletm]

Vinay kumar
this is one possible ...