Re: Convert minutes to hours and minutes in printed report

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: KevinW (belkur_at_msn.com)
Date: 07/29/04 

Date: 28 Jul 2004 17:50:20 -0700

"Rob Diamant" <rob@usi.com> wrote in message news:<ud2gAdLdEHA.1000@TK2MSFTNGP12.phx.gbl>...
> Kevin try this formula:
>
> cTime (Truncate (90 / 60), Remainder (90, 60), 0)
>
> Rob
>
> "KevinW" <belkur@msn.com> wrote in message
> news:ffdfa1fa.0407280429.7a6e02d3@posting.google.com...
> > I have vb.net program which does billing. One column in the database
> > has the number of minutes spent on a project. In vb.net I can convert
> > this to hours and minutes (e.g. 90 converts to 1:30), however, I need
> > to do this in Crystal when I print the report. Right now I have
> > Crystal connect to the dataset to get this column which it does
> > without a problem. Thus what I need to do is have Crystal do the
> > conversion into minutes. Ideally I would like it to examine each entry
> > to determine if it is greater than 59 and then do the conversion.
> > This seems like a formatting issue but I can't find a way to do it.

You are correct, I want a string such as "1:20" meaning 1 hour and 20
minutes, not 1:20 pm. However, my question is where do I insert the
formula? Do I somehow use the format editor or some other report
expert. Just starting on CR so this in not particularly clear.
Thanks.

Relevant Pages

  • RE: updated numbers in report
    ... for making an input to the database. ... textbox will be located alongside with the combobox where the belonging ... belonging query for the report. ... ElapsedTime([Date First Time Onboard], ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Creating a report entirely through code
    ... In my case this is a very simple database, ... >> thus greatly increase the probability of corruption. ... >> button doesn't gray out after a compile, a control starts to ... >>>report and not a form where they have to enter data in. ...
    (microsoft.public.access.formscoding)
  • Re: Creating Access DB
    ... database and in the SQL database that your report needs. ... click the query tab. ...
    (microsoft.public.excel.programming)
  • Re: MSSQL$SBSMonitoring Database size (SBS2003)
    ... You can use the SQL Client Utilities to try and shrink the database. ... to delete over 90 day old information from the monitoring ... The server will start to collect new counter value ... Check 'View the usage report in Server Management' option. ...
    (microsoft.public.windows.server.sbs)
  • Re: Suggestion
    ... Datamarts allow you to create summarized data and improve the query response ... You have to choose the better source regarding the report you have to ... Detailed information can query your OLTP data sources. ... >> Keeping the historical vs. current data partitioned by database is ...
    (microsoft.public.sqlserver.datawarehouse)