General information
Category:
Reports & Report designer
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only