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.Value ="H",format(sum(fields!Time.Value, "HH:mm"))

=FLOOR(Sum(Fields!Time.Value) / 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