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