Report Builder 3.0 hours Expression
How can i Add working hours?(HH:MM) A user will be working in different project. i have to claculate his working hours in a month to display. (so i might go for days) Thanks & Regards, Andrew Subash V
August 16th, 2012 4:07am

But i wanna display everything in hours only.. i.e if a user worked for 3 days 2 hours and 45 min means(74:45)...i expect it to be displayed as 24*3=72 72+2=74 74:45 -Andrew Subash V
Free Windows Admin Tool Kit Click here and download it now
August 16th, 2012 4:09am

Hello Andrew, you have to use VB code for that calculation to get result easily in report. are you fetching two different dates for fetching time? or just total days?Touseef Find More SSRS Topics @ Blog: touseefsk/CrazyErrors
August 16th, 2012 5:21am

Touseef Kariyania, I'm doing this reports for share point sites (Lists) . They are just hours only...simply working hours like 03:55(3 hours and fifty five min) , 11:45(11 hours and forty five min) , 00:10 (10 min) - Andrew Subash V
Free Windows Admin Tool Kit Click here and download it now
August 16th, 2012 6:28am

You have to compute SUM(hours*60+min), that will give you the total number of minutes. In your example, 03:55 + 11:45 + 00:10 = (3*60+55)+(11*60+45)+(0*60+10) = 235+705+10 = 950 minutes Then divide 950 by 60, that will give you 15 (hours) and a remainder of 50 (minutes) That is : 15:50.Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu
August 16th, 2012 8:10am

You have to compute SUM(hours*60+min), that will give you the total number of minutes. In your example, 03:55 + 11:45 + 00:10 = (3*60+55)+(11*60+45)+(0*60+10) = 235+705+10 = 950 minutes Then divide 950 by 60, that will give you 15 (hours) and a remainder of 50 (minutes) That is : 15:50.Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu
Free Windows Admin Tool Kit Click here and download it now
August 16th, 2012 8:16am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics