Time field on SSRS Report Expression display

(0) Share

Report

Posted on by DEEPAKNONU

207

I'm creating Query Base Report in my "Time Attendance Table" have Time field when i put this field on sssrs report it will show like this "HH:mm:ss". I need to show time on my report please help me how can i show time on my report.

*This post is locked for comments

I have the same question (0)

All responses (23)

Answers (0)

Sort by

Sohaib Cheema 49,668 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

what issue are you facing exactly? e.g. how to display it on SSRS? or formatting of "HH:mm:ss" or something else?

Was this reply helpful? Yes No
Suggested answer

Hajish 460 on at

Like
a
(0)

Report
Copy link

Link copied!

In cell properties, you can change the date format as you need.

Was this reply helpful? Yes No
DEEPAKNONU 207 on at

Like
a
(0)

Report
Copy link

Link copied!

Mr. Sohaib i have one table tablename "AttendanceTimeTable" it's a customized table in this table one field is for time for.eg. "Time In is 8:00 Am " and "Time out is 6:00 Pm".

I created a query base ssrs report when i take this field and use in my report it will show like this "HH:mm:ss" it not shows the time.

Was this reply helpful? Yes No
DEEPAKNONU 207 on at

Like
a
(0)

Report
Copy link

Link copied!

Mr. Hajish thanks for response but i need to show time not date.

Was this reply helpful? Yes No
Sohaib Cheema 49,668 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

is not "HH:mm:ss" the time???

by the way if you are confuse about AM/PM with format, you can change that by using textbox properties.

i.stack.imgur.com/NTNNM.png

Was this reply helpful? Yes No
DEEPAKNONU 207 on at

Like
a
(0)

Report
Copy link

Link copied!

Mr. Sohaib thanks for your quick response but i already check by changing properties of text box but when i change the properties it shows "h:mm tt" its not any type of error but when i run my report it show this field shows this "h:mm tt".

Was this reply helpful? Yes No
Sohaib Cheema 49,668 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

what do you want ? do you want to show AM/PM with it or something else?

Was this reply helpful? Yes No
DEEPAKNONU 207 on at

Like
a
(0)

Report
Copy link

Link copied!

I just want to show for eg:- 8:30AM

Was this reply helpful? Yes No
Sohaib Cheema 49,668 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I would recommend you to use custom format, as shown below, if you are unable to choose a workable format.

Was this reply helpful? Yes No
DEEPAKNONU 207 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for response but is also not working again shows "hh:mm:ss tt"

Was this reply helpful? Yes No