If you have a time in a decimal format, i.e. an integer and a fraction, e.g. 2.5 hours (2 and a half hours) and you want to convert to a standard time format 02:30 (2 hours and 30 minutes), then you can use a formula based on the TIME function with the following syntax:

TIME(hours,minutes,seconds)

Example:

We have a decimal time 2.5 in cell A2. we can use the following formula to convert it to a standard time:

=TIME(INT(A2);(A2-INT(A2))*60;0)

- The first parameter in this formula, hours is equal to the integer part of the decimal value: INT(A2).
- The second parameter, minutes is equal to the fraction of the decimal value multiplied by 60: (A2-INT(A2))*60.
- The last parameter seconds, is set to 0 in our example.

Below are different examples based on this formula:

*Applies to Excel 2003
*