hi,
I have a list using Nintex form to collect everyone's check-in time and check-out time, I want to add another column to use check-out time and check-in time to calculate the total hours and minutes this person worked in a day.
I tried some formulas, but I failed to generate the result, anyone has best practices can share with me? thanks!
Cheers,
Zoe
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.