How to calculate total job/ Total Hours

[vengadeshpalani]

Hi all

i have field like total Job and Total hours related to employee i need to to show Total Job / Total Hours and Total Hours / Total Job but it show wrong data

how i want to calculate that, please find attachment for sample Qvw  

[sunny_talwar]

What is wrong output?? What is the expected output

[vengadeshpalani]

[sunny_talwar · Accepted solution]

Your time is in seconds, you need to divide by 24... try this

Count(JobID)/sum(TotalSec)/24

[vengadeshpalani]

what is the logic, can u explain based on day, hour, minutes, seconds

[sunny_talwar]

No logic, just converting your seconds into a day