I need to convert seconds to minutes

[reenad99]

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]

Mins = Seconds / 60

 

[reenad99]

Mins = Seconds / 60

sorry, do I put that in the expression box then with the field title?

 

[boblarson]

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]

(notice the backwards slash - that gives you a whole number without any remainder).

Thanks bob just learnt something new