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:
We have a decimal time 2.5 in cell A2. we can use the following formula to convert it to a standard time:
- 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