Conversion of Time

[#1]

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 ??

[bruno_m_santos]

Try this:

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

Bruno

[#3]

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

[tresesco]

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

[#5]

Hey Tresesco ,

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

[maxgro]

maybe

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

[ashfaq_haseeb]

may be like this

Regards

ASHFAQ

[tresesco · Accepted solution]

See attached, it's working.

[#9]

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

[ashfaq_haseeb]

Hi,

did you checked my file?

Regards

ASHFAQ