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!

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

minutes convertion in crystal report 2

Status
Not open for further replies.

bharathi228

Programmer
Feb 12, 2009
12
hi

how to convert totalminutes to hours: minutes in crystal report

for example i have 10669 minutes

here i want to convert this into 77:24 like this
 
Create formula
@Time

local number hours;
local numbervar mins;

hours:=Int({minutes}/60);
mins:= remainder({minutes},60);

totext(hours, 0, "")& ":" & totext(mins, "00",0,"")

Ian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top