reenad99
03-24-2007, 03:38 PM
I want to convert a number field of seconds into minutes on a report - seems easy enough but can't figure it out. Any ideas?
|
View Full Version : I need to convert seconds to minutes reenad99 03-24-2007, 03:38 PM I want to convert a number field of seconds into minutes on a report - seems easy enough but can't figure it out. Any ideas? Dreamweaver 03-24-2007, 03:48 PM Mins = Seconds / 60 reenad99 03-24-2007, 03:51 PM Mins = Seconds / 60 sorry, do I put that in the expression box then with the field title? boblarson 03-24-2007, 03:52 PM And if you want no decimal places, just the number of WHOLE minutes, use In your report's control source: = [YourSecondsField] \ 60 (notice the backwards slash - that gives you a whole number without any remainder). Dreamweaver 03-24-2007, 06:18 PM (notice the backwards slash - that gives you a whole number without any remainder). Thanks bob just learnt something new :D |