Time / counting

[handysmurf]

Two questions ... is there a formula that will count conditionally? In other words count the number of times the code "j" appears in a column.

Second ... I have one column that subtract time and the result is in minutes in this format "00:07:23" I need this as a decimal by either altering the existing formula or by another column. The present formula simply subtracts the begin from the end.

 

[oldbrewer]

=countif(a1:a10,"j") counts the j's

do you want 7:23 to be 7.38 minutes

 

[handysmurf]

thank you and yes to the question

 

[oldbrewer]

00:07:23		07.38
		=VALUE(MID(TEXT(A1,"hh:mm:ss"),4,2))+VALUE(RIGHT(TEXT(A1,"hh:mm:ss"),2))/60

<colgroup><col><col span="11"></colgroup><tbody>
</tbody>

 

[MARZIOTULLIO]

	a​	b​	c​
1​	00:00:7:23	7:23​	7.38​

<tbody>
</tbody>

b1=RIGHT(A1,4)+0 custom format column b h:mm

c1=b1*24 format column c as number with two decimal

 

[handysmurf]

Excellent .... thanks!