Is the data text, or date/time? If it's text then shg's solution should work. If it's date/time then it is being stored as "days since January 1 1900". Date/time in Excel is a floating point number in units of days. To get hours just multiply by 24:

=INT(A1)*24