Best answer

I'm trying to create Zoho invoices from Clickup time tracking

  • 13 October 2022
  • 2 replies
  • 47 views

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!

icon

Best answer by robschmidt 13 October 2022, 03:46

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Thanks so much, Rob!

Userlevel 7
Badge +9

Hi @bthickey 

The hours information is in milliseconds

Here is the conversion formula:

You can use Formatter>Number>Spreadsheet style formula to convert ms to hours.