Decimal Hour into Time?

Question

I have an hour field in a database like 1.4, 1.5, 1.7 that I need to convert back to HH:MM. What is the easiest way to do this?

Answer 1

Convert.ToDateTime(float)

Answer 2

TimeSpan.FromHours:

double value;
TimeSpan t = TimeSpan.FromHours(value);

Example:

Console.WriteLine(TimeSpan.FromHours(1.4)); // prints 01:24:00 to the console.

Answer 3

The HH (hour) figure is the number before the decimal.

To get the minutes figure, subtract the whole number portion so you only have the amount after the decimal, then multiply the fraction by 60 to get the minutes.