Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ??
See attached, it's working.
Try this:
=interval( TIMESTAMP2 - TIMESTAMP1, 'hh:mm')
Bruno
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
=Sum(Interval(@EndTime-@StartTime,'hh:mm'))
Hey Tresesco ,
I have tried above expression ...its not working, i have attached a test qvw file ... please see if you can help
maybe
go to Number tab in your chart and format as Interval with format pattern hh:mm
may be like this
Regards
ASHFAQ
See attached, it's working.
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
Hi,
did you checked my file?
Regards
ASHFAQ