How Do I Turn 2.75 Hours Into Minutes In Excel

Опубликовано: 14 Май 2026
на канале: Excel Primed
31
0

Confused by Excel’s decimal time format? Learn how to convert it into readable minutes—fast and accurately.

This Excel video teaches beginners how to add hours, minutes, or seconds to a time using the TIME function.

For instance, if you want to increase a time by 4 hours and 30 minutes, you'd use =A1+TIME(4, 30, 0). You can also add times together using the "+" symbol.

The video also covers converting between time zones using the =A1+($B$1/24) formula. For instance, if you're in a different time zone than your colleague, you can enter the time difference in column B and use the formula in column C to get the time in their zone. This method can also help with daylight saving time adjustments.

EXCEL PRIMED RECOMMENDED COURSES

**Excel Essentials - The A-Z Guide for Advanced Users:
https://excelprimed.com/courses/excel...

**Excel Essentials - The A-Z Guide for Beginners Level I:
https://excelprimed.com/courses/excel...

**Excel Essentials - The A-Z Guide for Beginners Level II:
https://excelprimed.com/courses/excel...

**Excel Essentials - The A-Z Guide for Intermediate Users:
https://excelprimed.com/courses/excel...

**Excel Formulas - Advanced Level I:
https://excelprimed.com/courses/excel...

**Excel Formulas - Advanced Level II:
https://excelprimed.com/courses/excel...

**Excel Formulas - Beginners Level I:
https://excelprimed.com/courses/excel...

**Excel Formulas - Beginners Level II:
https://excelprimed.com/courses/excel...

**Excel Formulas - Intermediate Level I:
https://excelprimed.com/courses/excel...

**Excel Formulas - Intermediate Level II:
https://excelprimed.com/courses/excel...

**Excel Data & Text Manipulation - Advanced Users:
https://excelprimed.com/courses/excel...

**Excel Data & Text Manipulation - Beginners:
https://excelprimed.com/courses/excel...

**Excel Data & Text Manipulation - Intermediate Users:
https://excelprimed.com/courses/excel...