how to calculate time to get the result in hours+ minutes

Hi Zoe,

Here is the answer, I guess Re: nintex time data type field

Christophe

hi Christophe,

I tried this as below, but can't get the result, I guess the column I connected is not in the right setting. Do you know what type of column I should create on SharePoint to link with this data? Thanks!

Zoe

Hi Zoe,

Save as data type must be Integer as it returns the number of hours with this formula.

Maybe best to use dateDiffMinutes for your case.

Regards,

Christophe

Hi Christophe,

I have changed it to Integer, but it doesn't work, maybe because the check-out time is using workflow to update on the item afterward?

so I tried another way which works well (so far) --- I created a new column (Single line of test type, using formula =([Check-Out Time]-[Check-In Time])*24

the result shows correctly in column Hours (column named Total Hours is the one using dateDiffMinutes, always shows 0.)

Zoe,

I am happy that it works the way you want.

But I have tested the method above and it works.

Christophe