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:
00341424
Views:
26
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform