In this Excel Tutorial I will show you how to use Hour Function in Excel 2010.
For purpose of this Tutorial I will use packing slip template.
Hour function allows us to returnee hour from value. I will show you base on the example.
Below I select my Order Time and I would like to returnee hour. I go to formula bar and type equal-hour next open parenthesis.
In the parenthesis I select Order Time - this will be my value. I close parenthesis.
Hour function returnees me correct time. At the picture below you can see this result,
You can also fin Hour function if you go to Formulas bar and click Date & Time functions. When we scroll down we will find correct Hour function.
As you can see I get the Function Arguments window. In the Serial Number I select my value (below we have description about serial number) I select the value.
I get Exactly the same result like in previous example.
I hope this Excel Tutorial was helpful.
Katie and Emil