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