Decimals as minutes to fraction of an hour

Excel Help for Decimals As Minutes To Fraction Of An Hour in Analyzing Corporate Financial Data

Find Excel Solutions


Search Forums:
Recent Activity:
Can't Get It To Give Me The Report I Want
Importing Data From Pdf Files
Need Help With Formulas And Fixing This Spreadsheet
Wanting To Calculate All Hours Worked On A Project With Timesheets
Simple Formulae For Creating Complex Interactive Dashboards In Excel
What Is Microsoft Project Gantt Chart Used For?




Follow Business Spreadsheets On:
 
Forum TopicLogin

Decimals As Minutes To Fraction Of An Hour

Rate this:
(3/5 from 1 vote)
OopsOK - So we assume here that the decimal part of the time represents the number of minutes.  the solution here is to separate the whole number (hours) and the decimal (minutes) to calculate the number of hours difference. We can do this by using the INT function that returns the whole number and then process the decimal part to calculate the fraction of an hour.

Assuming that the start time is in cell A1 and the end time is in B1, the formula to calculate the number of hours difference is:
=INT(B1-A1)+((B1-A1)-INT(B1-A1)-0.4)/0.6
 Excel Business Forums Administrator
 Posted by on
 
View the "Time difference" Topic

Find relevant Excel templates and add-ins for Decimals as minutes to fraction of an hour in the

 
Find Excel templates
and add-ins in the
Excel Business Solutions Directory
   
  © 2014 Business Spreadsheets. All Rights Reserved. Legal |