cancel
Showing results for 
Search instead for 
Did you mean: 
Nintex Newbie

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

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

Labels: (3)
Tags (2)
0 Kudos
Reply
5 Replies
Highlighted
Automation Master
Automation Master

Re: 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

Reply
Highlighted
Nintex Newbie

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

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

0 Kudos
Reply
Highlighted
Automation Master
Automation Master

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

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

0 Kudos
Reply
Highlighted
Nintex Newbie

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

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.)

Reply
Highlighted
Automation Master
Automation Master

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

Zoe,

I am happy that it works the way you want.

But I have tested the method above and it works.

Christophe

Reply