I use Clickup to track my projects and just manually enter the time worked in Clickup’s built-in time tracker. I’m trying to automate invoicing by sending that data to Zoho Invoice. When i try to send the time tracked, though, instead of showing up as hours, I’ll see some giant number like 7200000 instead of 2 hours. I don’t even understand the math that’s coming up with that. Anyone have any ideas? Thanks!
Best answer
I'm trying to create Zoho invoices from Clickup time tracking
- Beginner
- 1 reply
Best answer by robschmidtBest answer by robschmidt
Hi
The hours information is in milliseconds
Here is the conversion formula:
You can use Formatter>Number>Spreadsheet style formula to convert ms to hours.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+9- Zapier Expert
- 617 replies
- Answer
Hi
The hours information is in milliseconds
Here is the conversion formula:
You can use Formatter>Number>Spreadsheet style formula to convert ms to hours.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.