web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Decimal to Time conversion in report

(0) ShareShare
ReportReport
Posted on by 700

Hi All,

I have written the following expression on RDLC Layout of a report to display the time which is originally in decimal format to HH:MM:SS format. But it it displaying only hours and minutes and seconds are being displayed as 00. Please suggest the correct expression if I am making any mistake:

=Floor(Sum(Fields!Actual_Time.Value*3600) / 3600) & ":"& RIGHT("0" & Floor(Sum(Fields!Actual_Time.Value *3600)/ 60) - Floor(Sum(Fields!Actual_Time.Value*3600) / 3600) * 60, 2) & ":"& RIGHT("0" & Sum(Fields!Actual_Time.Value*3600) - Floor(Sum(Fields!Actual_Time.Value*3600) / 60) * 60, 2)

I need the solution early.

Thanks in advance !

  • Suggested answer
    Binesh Profile Picture
    7,887 on at

    Hello,

    try by adding the T as below, it gives you a time, now based on your requirement update the code.

    MESSAGE('New Time: %1',FORMAT((210513T),0));

    MESSAGE('New Time: %1',FORMAT((090513T),0));

  • Dynamics 365 Business Central Profile Picture
    700 on at

    How these statements are relevant to my code ? Sorry but I am not getting, could you please help a bit more !

  • Suggested answer
    THE Italian Profile Picture
    Microsoft Employee on at

    I would avoid doing all of these nested operations when rendering the report. I would better move the calculation within the dataset and pass the decimal value directly instead of calculating this each time.

    You can then use the FORMAT property for what you need to display as TIME

    docs.microsoft.com/.../format-property

  • Dynamics 365 Business Central Profile Picture
    700 on at

    Kindly provide me a way to achieve the same. Should I provide you with the source code ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 665 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 418 Super User 2026 Season 2

#3
Teagen Boll Profile Picture

Teagen Boll 280 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans