**Converting decimals to** minutes. **To convert time** expressed in **decimals** back **to** minutes you will simply take the **decimal** portion of the number, i.e. just the digits **to** the right of the **decimal** point, and multiply it by 60 (minutes in an hour). For example, if you have 1.45 hours, then take .45X60. This gives you 27.

Accordingly, what is 1 hour in decimal?

Time to Decimal Conversion Table

Time | Hours | Minutes |
---|---|---|

00:45:00 | 0.75 | 45 |

00:50:00 | 0.833333 | 50 |

00:55:00 | 0.916667 | 55 |

01:00:00 | 1 | 60 |

What is .1 of an hour?

Billing Increment Chart—Minutes to Tenths of an Hour

Minutes | Time |
---|---|

1-6 | .1 |

7-12 | .2 |

13-18 | .3 |

19-24 | .4 |

How do I convert time to decimal in Excel?

Type in the formula to **convert** minutes and seconds into a **decimal** number representing hours into the cell you selected. For example, type "=(A1-INT(A1))24 into cell B1, then press Enter. This formula converts the **time** you entered into a fraction of a day, then converts this fraction into hours.

**You May Like Also**