I am using My Time to track my time — and have been for years without incident. I just sent my recent activity to QuickBooks and not all of my activities are showing up. Complete days are missing. Any ideas?
So I exported the list and planned on adding the time manually then ran into another problem (if I need to post this separately, please let me know).
I can't figure out how the duration in My Time corresponds to the Quantity field in Quickbooks invoices. Can you help me figure out how that is calculated? For example, how does 1:33 from My Time show up as quantity of 1.71 in Quickbooks?
Appreciate your help, thank you!
Solved! Go to Solution.
Let's check if this is an issue with your company file. We'll run the Verify and Rebuild data utilities to check the integrity of your file and to resolve any damaged components that cause the missing data. You can follow the steps in this article: Resolve Data Damage On Your Company File.
If the Verify utility cannot detect any issues, please get in touch with our phone agents to check this further. They have a screen-sharing tool to help them see your setup and check this thoroughly. They can also check how your time quantity is being converted to a decimal value.
Here's how to get their number:
- Open this link: https://help.quickbooks.intuit.com/en_US/contact.
- Choose QuickBooks Mac Desktop.
- Select Using QuickBooks for Mac.
- Scroll down and click the Get Phone Number button.
If you have other questions, please don't hesitate to add a comment below.
For this Time Math: "how does 1:33 from My Time show up as quantity of 1.71 in Quickbooks?"
Pay attention to the Punctuation.
60 minutes = 1 hour
So, 1 minute = 1/60th as Decimal, or Fraction. Or, 1 minute as hours and minutes, using Punctuation.
1 hour and 30 minutes = 1 COLON 30
1 hour and 30 minutes = 1 POINT 5 (for 1 and one-half)
.1 of an hour = 6 minutes
33 minutes is .55
43 minutes is .71
Money is multiplied by Decimal Time, for currency values.