General discussion

Hi,
I would like to find an equation that allow me to find a number if it is in a range of numbering 
I attachd a file .xls as un example,
Thank you.

Hi All,
I have column of duration in second and i need to round it : first to 60 and to 30 by creating two column.
Using @Round isn't very helpful for me, so ; is there any function ? or should i use @Round with another function,
Thank you.

Hi,
I need to do a calcul to get a result in percentage % , so is there any function or script to do it ?
as alternative solution what I'm doing is : creating new numeric field and I insert this fomule : (Column A / Column B )*100  
Thank you.

Hi;
I've a database that I need to compare between the line 1 and the line 2 ...e, 
for example :  
In this case; i need to get the difference between the start call of line 2 with the end call of line 1  and 
 Thank you.

START CALL
DURATION
Duration_HOURS 
End_Call

17:26:18
139
00:02:19
17:28:37

17:28:50
60
00:01:00
17:29:50

17:29:52
45
00:00:45
17:30:37

Hello everybody,
I am having difficulty in appending multiple sheets importing from excel. Why i tried to join these sheet together, the system notify me about the field format is different. Is there a way or any tips to mass formatting multiples sheets at one? Since having 50+ sheets to append might be time consuming.
Thank you very much,
Best regards,
Trung Nguyen

Hi All,
I need to deal with a field ( numeric type) containing a number called duration with this format for example : 14100 wich mean that the duration is 101 second, another exmaple :
1333800 = 5618 second
1410100=6061 second
So which function ca help me to get the result in second ?
Thank you.

Hi All,
Can you help or guid me to extract without duplicated data  ? 
column A (character type ):
1  
2
1
4
5
1
3
Thanks.

Hi All,
I have a field that contains a list of number separated by (,), what i need is : create a lot of field depended of how number contained in it ,
for ex : 3554249, 3554250, 3554251, 3554252  and the result that i'd like is for ex :

A
B
C
D

3554249
3554250
3554251
3554252

Thank you.

Hello,
 
How many different kinds of IDEA license are there?
- Client Version
- Server Version
- Single User Version
- Shared User Version
 
I am purchasing new laptops to run IDEA on standalone mode (Client Version).
What is the recommended laptop specification?
 
Thanks and Regards!

Hello,
 
I am using IDEA by extending my desktop across my laptop screen and another big monitor.
 
But when I am using IDEA in my laptop, I realise that some windows in IDEA will be missing / out of sight. 
 
Is this an existing problem with IDEA? If yes, are there any resolutions for this?
 
Thanks and Regards!