Avatar of aneilg
aneilg
Flag for United Kingdom of Great Britain and Northern Ireland 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)
SSRS

Avatar of undefined
Last Comment
aneilg

8/22/2022 - Mon
selva_kongu

try this

Date.FromOADate(Sum(Fields!TheTime.Value.ToOADate())).ToString("hh:mm:ss")
aneilg

ASKER
i just get an error #Error.
aneilg

ASKER
my time is as follows: HH:mm. no seconds.

thanks.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
selva_kongu

Please refer the Link
aneilg

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.
santhimurthyd

How the Time.Value format, whether it's 12:30 else 12.30
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
aneilg

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
aneilg

ASKER
no answer given