Technical Questions: converting minute to hours formula

Print Page | Close Window

converting minute to hours formula

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=6722
Printed Date: 03 May 2024 at 10:16pm

Topic: converting minute to hours formula

Posted By: jrs1234
Subject: converting minute to hours formula
Date Posted: 15 Jun 2009 at 8:20am

Hello,

I have a database field called VisitTime - it has minutes only. I need to have the report to convert those minutes into the HH:MM formula. I am sure this is easy but I am stumped.

Thanks,

Replies:

Posted By: DBlank
Date Posted: 15 Jun 2009 at 2:15pm

totext(( mailto:%7b@1234%7d,60%29%29/60 - {table.visitTime}-remainder({table.visitTime},60))/60 ) + ":" + totext(remainder( mailto:%7b@1234%7d,60 - {table.visitTime},60 ))

Posted By: jrs1234
Date Posted: 15 Jun 2009 at 2:24pm

Thanks - that worked!

Print Page | Close Window