topic Re: Conversion of Time in QlikView

Conversion of Time

Mon, 02 Jun 2014 10:28:17 GMT

I want to calculate total working hours of a faculty

Faculty session start time is given and session End time is given

i have calculated session duration by subtracting start time from end time.

now i want to calculate total hours and minutes a faculty has taken the lecture in 2013 year but time has limitation of 24 hrs(24:00:00) so its useless here

for e.g faculty faculty id : 20 has taken lecture of 90 Hrs and 30 min in year 2013 ( assumed value)

what expression i should use for calculating Session duration ??

Re: Conversion of Time

bruno_m_santos — Mon, 02 Jun 2014 10:32:05 GMT

Try this:

=interval( TIMESTAMP2 - TIMESTAMP1, 'hh:mm')

Bruno

Re: Conversion of Time

Mon, 02 Jun 2014 10:45:26 GMT

its not working i have tried it ... i have given a test QVW file please try the given expression in session duration at backend of the qvw

Re: Conversion of Time

tresB — Mon, 02 Jun 2014 10:46:21 GMT

=Sum(Interval(@EndTime-@StartTime,'hh:mm'))

Re: Conversion of Time

Mon, 02 Jun 2014 10:50:49 GMT

Hey Tresesco ,

I have tried above expression ...its not working, i have attached a test qvw file ... please see if you can help

Re: Conversion of Time

maxgro — Mon, 02 Jun 2014 10:51:18 GMT

maybe

go to Number tab in your chart and format as Interval with format pattern hh:mm

Re: Conversion of Time

ashfaq_haseeb — Mon, 02 Jun 2014 10:53:55 GMT

may be like this

Regards

ASHFAQ

Re: Re: Conversion of Time

tresB — Mon, 02 Jun 2014 10:55:19 GMT

See attached, it's working.

Re: Conversion of Time

Mon, 02 Jun 2014 11:02:12 GMT

Hi,

Script should be something like...

Load

%AttendanceDate,
Year(%AttendanceDate) as Year,
%FacultyID,
@StartTime,
@EndTime,
Date(@EndTime-@StartTime,'hh:mm') as T_Time
FROM
time.xlsx
(ooxml, embedded labels, table is Sheet1);

And you expression ...

sum(T_Time)

Change to number format "interval"

Vinay

Re: Conversion of Time

ashfaq_haseeb — Mon, 02 Jun 2014 11:06:35 GMT

Hi,

did you checked my file?

Regards

ASHFAQ

Re: Conversion of Time

Mon, 02 Jun 2014 11:07:05 GMT

Thank you all

I am very grateful to all you guys..