truncate "hh:mm:ss" to have just "hh"
If your time is stored properly as time, you can use this formula:
=HOUR(A1)
If it's stored as text, then use this:
=VALUE(LEFT(A1,2))
Both cases, if you want to display 09 instead of 9, then right-click on your cell, select number formatting - custom and enter 00.
Create the custom cell format directly, select the cell and right click- select Format Cells...- Under Number tab select Custom and enter hh
