Time (in field)

[Anonymous]

I am new at Qlikview...

I have excel files where the time is included in a specific field called "DESCRIPTION", where the last 5 digits in that field are time specific and to be considered, i.e. "03:00".

However some rows do not include a time (but other information) and should therefor not be considered, or at least considered as "00:00".

How can I read out the time stamp from the "DESCRIPTION" field.

Example.....

DATE               TYPE        AMOUNT          DESCRIPTION         

01/01/2018      CR             100                    CRN: 013141345, RRN: 04641508 B/O: SFER NAME/ ADRESS POST 03:00

[m_woolf]

Maybe something like:

=if(IsNum(right(DESCRIPTION,5)),right(DESCRIPTION,5),'00:00') as MyTime

[Anonymous]

Thanks! Working fine.

How can I now group time into 60 minutes intervalls?

[m_woolf]

=floor(frac(STARTTIME)*24)/24+floor(STARTTIME)   as LowestHour