Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to convert decimal numbers to Hours and minutes

Status
Not open for further replies.
balushanmugham

balushanmugham

Programmer
Jun 16, 2012
6
IN
Hi,

I am using SSRS 2005. I want to convert decimal numbers to Hours and minutes.

Say suppose, I am adding daily work hours and minutes and the total is 208.63.
Here 208 hrs and 63 minutes. How to convert this to 209 hrs 03 minutes in SSRS.
Any In-built function is there? or how to do using custom code?

Appreciate your help.
Regards,
Bala
 
Status
Not open for further replies.

Similar threads

tarikqazza
  • Locked
  • Question
SSRS server connection to datasource fail randomly ( sql server 2016)
Replies
0
Views
325
tarikqazza
tarikqazza
dbsql
  • Locked
  • Question
SSRS2019 not able to connect Oracle19
Replies
0
Views
316
dbsql
dbsql
Colin Burton
  • Locked
  • Question
SSRS - access to "master" Sys function xp_fileexist
Replies
1
Views
375
fredericofonseca
fredericofonseca
Ashajohn2021
  • Locked
  • Question
Report to give Average # of cases > than 6, 7, 8 days
Replies
0
Views
299
Ashajohn2021
Ashajohn2021
feltonam
  • Locked
  • Question
How to select Patients with >5 Appts and get the very 1st Appt date in same Script
Replies
1
Views
117
johnherman
johnherman

Part and Inventory Search

Sponsor

Back
Top