Look Who it Was Random video

Excel Calculate Decimal Hours from two Time Cells - Episode 902

1,176 views · Published 10 December 2008 · 2:13 · Indexed 30 October 2026

Channel: MrExcel.com · 2008 · Education

Watch on YouTube

Microsoft Excel Tutorial: Converting times to decimal hours.

Welcome to another episode of the MrExcel netcast! Today, we're helping Greg with a worksheet problem. He has two times and needs to figure out the difference between them. Normally, we'd just subtract the two times, but Greg needs to show the number of hours and a fractional number of hours.

The way Excel stores time is as a decimal between 0 and 1. For example, 6 hours would be 0.25 because it's 25% of a day. To solve this problem, we need to take the subtraction and multiply the whole thing by 24. Then, we can use Format Cells to change the number of decimal places.

Using this method, we can easily total up the number of hours, even if it's in excess of 24. We don't have to use the secret number format anymore! Thanks for joining us, and we'll see you next time for another netcast from MrExcel.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Today's Excel question from Greg.

Calculate time difference in Excel and show the result as a decimal number of hours. Episode 902 will show you how.


Table of Contents
(0:00) Theme Song
(0:15) Problem Statement: Show Difference between Times
(0:42) Hours and Decimal portion of hours in Excel
(1:06) Multiply time in Excel by 24 to convert to hours 
(1:35) Totaling Hours in Excel
(1:55) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Changing number format in Excel
Converting time to decimal in Excel
Converting time to hours and minutes in Excel
Exceeding 24 hours in Excel
Excel Ctrl+1 shortcut
Excel time calculation
Excel time difference formula
Format Cells in Excel
Multiplying time by 24 in Excel
Solving time calculation issues in Excel
Totaling hours in Excel


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1151925/

More from this channel