Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

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
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:


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

KB ID# HOW13002
10/4/2015 12:37:06 PM
QYPPRDQBKSWS10 9125 Pro 2015 3aba0c