Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

Using Microsoft Excel to Calculate Time in Hours and Minutes from Start and Stop Times

The Time Tracking module of QuickBooks accepts time data in hours and minutes using the minutes and decimal formats (e.g. 9:34 or 9.57).

Detailed Instructions
To calculate the duration from start and stop times using Microsoft Excel, set up the cells as this
A B C
1 Start 9:49
2 Stop 19:23
3 Hours/Minutes 9:34
4 Decimal 9.57
 
In cells C3 and C4, we will have Excel calculate the difference between the two times and provide the time in both formats. Copy the formulae below into each respective cell. To change the format of the cell, right-click and choose Format Cells...

The formulae are:

Cell

Formula Cell Format
C3 =SUM(B2-B1) Time (hh:mm)
C4 =INT((B3)*24)+(MINUTE(B3)/60) Number (with 2 decimal places)

If these steps do not resolve the issue, you can read discussions and post messages and questions relating to your issue on the Intuit QuickBooks Community site for free or you can contact a technical support agent for additional guidance. Fees may apply.

KB ID# HOW13002
7/24/2014 2:39:15 PM
PPRDQSSWS406 9102 Pro 2013 cac30a