Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Total Minutes to Hours Minutes in Report Group
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00341419
Message ID:
00341427
Views:
24
Rick,

Pretty cool!! Thanks


>>I need to print a total Hours and Minutes on a group break of a report. The table I am reporting from has a "Total minutes" field. What's the best way to do this from within the report?
>>
>>TIA
>-----------------------------------------------
>Alan,
>I recently did something like this...I had the seconds....
>
>I made my report field something like...
>IIF(nTime>3570,;
> ALLTRIM(STR(nTime/3600, 5,1))+' Hrs', ;
> ALLTRIM(STR(nTime/60, 5,1))+' min')
>
>3570 is 59 minutes and 30 seconds, so if it's 59.5 minutes I show hours otherwise I show minutes....if you need both then it's a simple elaboration from here.
>
>Hope this helps....
>
>Rick
Alan Trosky
MIS Director
Pennsylvania Bar Association
Harrisburg PA 17108
Previous
Reply
Map
View

Click here to load this message in the networking platform