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 4 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 4 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 2 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.