Time format

[#1]

Hi All,

Time should be shown as 1-2AM, 2-3AM similarly till 22-23PM 23-24

Please help me with this.

Thanks,

Keerthi KS

[robert_mika]

What is your base data?

[senpradip007]

Can you share sample data?

[#4]

Date and Time

2014-12-31 06:23:46.480

2015-01-01 04:34:51.893

2015-01-05 08:33:49.000

[avinashelite]

Hi Keerthi,

Please find the attachment for the solution

[sunny_talwar]

May be this:

Table:

LOAD *,

  Time(Floor(Time, 1/24), 'h') &'-' & Time(Ceil(Time, 1/24), 'h TT') as TimeRange;

LOAD [Date and Time],

  Time(Frac([Date and Time])) as Time,

  Date(Floor([Date and Time])) as Date;

LOAD * Inline [

Date and Time

2014-12-31 06:23:46.480

2015-01-01 04:34:51.893

2015-01-05 08:33:49.000

];

Output in Table Box:

[#7]

Thanks a lot Avinash.

Please send for the below format

6-9AM

9-10AM

10-11AM

11- 12N

12-1PM

1-2PM

2-3PM

3-4PM

4-5PM

5-6PM

6-7PM

7-8PM

8-9PM

9PM -12AM

12-6AM

[sunny_talwar]

May be something like this for customized ranges:

Table:

LOAD *,

If(Time <= (6/24), '12-6 AM',

  If(Time <= (9/24), '6-9AM',

  If(Time <= (21/24), Time(Floor(Time, 1/24), 'h') &'-' & Time(Ceil(Time, 1/24), 'h TT'), '9-12PM'))) as TimeRange;

LOAD [Date and Time],

  Time(Frac([Date and Time])) as Time,

  Date(Floor([Date and Time])) as Date;

LOAD * Inline [

Date and Time

2014-12-31 06:23:46.480

2015-01-01 04:34:51.893

2015-01-05 08:33:49.000

];

[avinashelite]

please find the attachment for the solution

[#10]

Hi Sunny,

Please find the attached QVW.

I am not able to get the Time Range.

Its showing but dates are not matching.

Please help me with this.

Regards,

Keerthi KS