aneilg
asked on
SSRS Expressions How to add/sum time.
i have the following expression but i cannot seem to sum/add the time.
i've tried
=iif(fields!PercentFlag.Va lue ="H",format(sum(fields!Tim e.Value, "HH:mm"))
=FLOOR(Sum(Fields!Time.Val ue) / 60) & ":"
& RIGHT("0" & (Sum(Fields!Time.Value) MOD 60), 2)
i've tried
=iif(fields!PercentFlag.Va
=FLOOR(Sum(Fields!Time.Val
& RIGHT("0" & (Sum(Fields!Time.Value) MOD 60), 2)
ASKER
i just get an error #Error.
ASKER
my time is as follows: HH:mm. no seconds.
thanks.
thanks.
Please refer the Link
ASKER
i've had alook at that link, but its not what i want.
thaey are using "s",date1,date2.
i am only using one date and no seconds.
thaey are using "s",date1,date2.
i am only using one date and no seconds.
How the Time.Value format, whether it's 12:30 else 12.30
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
no answer given
Date.FromOADate(Sum(Fields