How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Andy Your Own Question
Andy, Computer Engineer
Category: Microsoft Office
Satisfied Customers: 23538
Experience:  Experienced in all versions of MS Office Products.
Type Your Microsoft Office Question Here...
Andy is online now
A new question is answered every 9 seconds

How do I format a cell to record minutes only

This answer was rated:

How do I format a cell to record minutes only
I am Andy and I will be glad to help you out with your issue today. Please Reply to me with doubts / questions till you are 100% satisfied.

Please do this and let me know result via the REPLY TO EXPERT button.

Create a Cell (lets call it A1) with format Time : hh:mm

Create another cell next to it (or anywhere) with formula : {A1}*1440
The format of this cell should be numbers with no decimals.

For detailed instructions please see this : LINK

Let me know result via the REPLY TO EXPERT button.
Customer: replied 5 years ago.



I am working on a spreadsheet which records the following data:


degrees; minutes; seconds


I use a separate cell to record each piece of data and then I need to create a formula to convert the minutes & seconds to degrees and add up the three columns


In your question you have mentioned "How do I format a cell to record minutes only"

Are you done with that question ?

Customer: replied 5 years ago.



Yes - that has solved my initial question.

However, I would like you to continue and answer my query with the spreadsheet - or do I have to submit another request


Thank you for your confirmation.

Please go ahead and RATE this answer with 5 stars / Smiley face so that I get credited for my answer through this website.

Only after that we can continue to work on your second question.

Thanks and take care!
Andy and other Microsoft Office Specialists are ready to help you

Now, please goto the following link and post your second question :

Either myself .. or some other expert will get back to you asap on that.