hour to number

[emm8080]

Hi again

How can I covert 12:01:13 to just 12 (ie hour) but format the hour as
number.

Basically, I have a time (12:01:13) which I formatted using "hh", s
the time is now displayed as 12, but when I try to use the hh (ie 12
in the following function (cell $A18) it returns the value of 0


=SUM(IF(FREQUENCY(IF((Clicks!$B$2:INDEX(Clicks!$B:$B,Clicks!$X$2)=$A18),MATCH(Clicks!$H$2:INDEX(Clicks!$H:$H,Clicks!$X$2),Clicks!$H$2:INDEX(Clicks!$H:$H,Clicks!$X$2),0),""),IF((Clicks!$B$2:INDEX(Clicks!$B:$B,Clicks!$X$2)=$A18),MATCH(Clicks!$H$2:INDEX(Clicks!$H:$H,Clicks!$X$2),Clicks!$H$2:INDEX(Clicks!$H:$H,Clicks!$X$2),0),""))>0,1))

I think it has something to do with it being a time format. I need t
change the time format to a normal number.

Any ideas?

thx

Emm

 

[Frank Kabel]

Hi
use
=INT(A1*24)

or if you want to round is try
=ROUND(A1*24,0)

and use this value for your calculation

 

[emm8080]

excellent!

Thanks Frank


Emm

 

[Dana DeLouis]

How can I covert 12:01:13 to just 12 (ie hour)

Would this work?

=HOUR(A1)

Dana