Link to home
Start Free TrialLog in
Avatar of heyday2004
heyday2004

asked on

To display mm:ss format in Excel

I have an excel file, with a simple pivot table. I have a field with the data stored as number of seconds, say 91 second.  How could I change the excel file cell setting so it will be displayed in mm:ss format, like 01:31? Any quick way to do that? Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of heyday2004
heyday2004

ASKER

many thanks.