Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 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
    4 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.

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

The add'l calculation is what I was missing.   It is now working!    Thanks.