create new column

[soniasweety]

Hi all,

I have a  time table  and opentime in   main table

I want to create a new column based on that   like

opentime+time as  DeadlineTime

how to create this ?

Main table  column[open time]  created like below

Time#(Right("OpenTime",8),'hh:mm:ss') as "Open Time"

Time table:

Load * Inline [

PId,Time[In minitue]

1,15

2,30

3,600

4,120

];

how can I achieve this?

Thanks

Sony

[Anil_Babu_Samineni]

Try this? If Time is in Hours..

[Open Time] + Date(Date#("Time [In minute]", 'hh'), 'hh:mm:ss') as New_Column;

[soniasweety]

not working because my open time column values giving wrong

how to set to this correct hh:mm:ss format

this is giving output below not working

Time#(Right("OpenTime",8),'hh:mm:ss') as "Open Time"

[Anil_Babu_Samineni]

May be this?

=Date(Num#(Right("OpenTime",8)),'hh:mm:ss') as "Open Time"

[soniasweety]

its givng like below

[Anil_Babu_Samineni]

Can you share the sample file to test

[soniasweety]

not possible

[Anil_Babu_Samineni]

No need to share, Server one. You ca create 2 fields which is Time and OpenTime to check from real data values..

[Or]

Interval(Time#(Right("OpenTime",8),'hh:mm:ss') + (Time[In minitue]/1440))

When using math operators with time 1.0 equals one day, so divide minutes by 1440 minutes (in one day). Format as interval (NOT as time), or anything that took over 24 hours will show up incorrectly. 

[soniasweety]

still no luck its giving null