Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date/Time as Duration

I have an Excel export that I've successfully converted the date/time to a duration I can use to calculate time spent on projects.   However, time over 24 hours in the data table shows "error".   Wha...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    Hi Anonymous 

    what does the column [Minutes] represent to? 2.67 day? if so, you need to convert 2.67 day to minutes firstly, minutes = 2.67*24*60, then you can put it into the code template.

    for example,

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.