Sunday, September 25, 2011

Hour Formula



Number
Hour


21:15
21
 =HOUR(C4)

0.25
6
 =HOUR(C5)




What Does It Do?


The function will show the hour of the day based upon a time or a number.




Syntax



 =HOUR(Number)






Formatting


The result will be shown as a normal number between 0 and 23.