2 Replies Latest reply on Jul 29, 2015 7:25 PM by Bevan Hirst

Help me add minutes to my equation!

Hi guys

I'm using the following equation to determine the number of people finishing after a certain time, in this case 3pm:

COUNTD(if([DateTimeEnded (Hours)])>=15 then [Employee Number] end)

I actually want to determine how many people finish after 3:30pm

How is this possible?? I've tried adding decimals '15.5' but then it just calculates the threshold @ 4pm instead

I tried using dashes '15-5' but I believe this number is then converted to a date function.

Can someone help?

Thanks

• 1. Re: Help me add minutes to my equation!

You can try something like:

IF DATEPART('hour', ATTR([Your Date])) >= 15 and datepart('minute', ATTR([Your Date])) >= 30

THEN count([Employee Number]) END

A lot also depends on how you have your view set up. So if this doesn't work, some screenshots or even better a sample workbook would help.

Thanks,

Pooja

• 2. Re: Help me add minutes to my equation!

Thanks Pooja, I had to alter it slightly for my purpose but it worked great.