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
Andy, Computer Engineer
Category: Microsoft Office
Satisfied Customers: 23538
Experience:  Experienced in all versions of MS Office Products.
16465236
Type Your Microsoft Office Question Here...
Andy is online now
A new question is answered every 9 seconds

Andy, I was very happy with your prompt response to my previous

Resolved Question:

Andy,

I was very happy with your prompt response to my previous query and was hoping that you would be able to assist me by providing the following information:

1. Formula to format a cell to record seconds

2. Formula to convert minutes to degrees

3. Formula to convert seconds to degrees
Submitted: 2 years ago.
Category: Microsoft Office
Expert:  Andy replied 2 years ago.
Hello!
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.

Lets do this step by step ... 1 formula at a time .. is that Okay ?

So, lets work on your Formula to record seconds.

Take a cell D1 and format it to General (or Number).

Use this following formula in D1:

=B1*24*3600

where B1 would be the cell in which your Time (hours:mins:seconds) would be stored.

Do this and let me know result please.

Let me know result via REPLY TO EXPERT button
Andy
Customer: replied 2 years ago.

Andy,


 


Result works

Expert:  Andy replied 2 years ago.
Hi,

Do you have any further questions or are you happy with my help ?

Andy
Customer: replied 2 years ago.

Andy,


 


I also need separate formulas to convert minutes & seconds to degrees

Expert:  Andy replied 2 years ago.
Hi,

Please give me an example for both of these.

Andy
Customer: replied 2 years ago.

Andy,


 


I have attached a link below to download a sample file. What I would like is the following:


 


1. A formula to convert the minutes/seconds columns (yellow) to degrees. I need to add these figures to the degrees column


 


http://wikisend.com/download/537444/Theodolite Pre Op Check.xls

Expert:  Andy replied 2 years ago.
Hi Stephen,

I am very sorry for asking you so many questions ... but I just want to be 100% sure about what you need.

1. Do you want to convert Minute to Degree .... then Seconds to Degree .... and store both of them in 2 seperate cells.

2. Then you want to add (sum) those two cells ?

Is that correct ?

Andy
Customer: replied 2 years ago.

Andy,


 


What I actually need to do is the following, convert the minutes & seconds to degrees and then add them to both the degree figures in D15 & D16 (total figure will be recorded in cell D17)

Expert:  Andy replied 2 years ago.
Hi,

So, do you want convert E15+F15 and convert it to Degree .... a single Degree result and store it in say G15 ?

Then add G15 to D15 ... ??

What I am asking is ... Do you want to individually convert E15 to Degree ... and F15 to Degree ...
OR
Do you want to get a combined Degree result out of E15 and F15 ..

Andy
Customer: replied 2 years ago.

Andy,


 


It is the total figures in E17 (Minutes) & F17 (Seconds) that I need converted to degrees. I then need to add those figures to the degree figures in cells D15 & D16.


 


It does not matter whether it is a combined degree result of cells E17 & F17

Expert:  Andy replied 2 years ago.
Hi Stephen,

I am working on this ... I will get back to you ... please hold on.

Andy
Expert:  Andy replied 2 years ago.
Hi,

The result in D15 and D16 ... are they just dummy ... or correct ones ?

The decimal degree result of mm:ss (59:54) is 0.9983 ... is this the expected result for D17

Andy
Customer: replied 2 years ago.

Andy,


 


All entries are correct ones. The expected result for cell D17 should be 360 degrees (sum of D15, D16, E17 & F17)


The purpose of the excel file is to carry out pre-op checks of survey equipment

Expert:  Andy replied 2 years ago.
Hi,

So, the Degree result of (59:54) is 0.9983 ... which is 1 if rounded off.

So, the Sum would be become 360 ...

Is that correct ?

Andy
Customer: replied 2 years ago.

Yes

Expert:  Andy replied 2 years ago.
Hi,

Awesome ... so here is your formula ... sorry for taking so long !

Please put the following formula in cell D17 :
=((((F17/60)+E17))/60)+D15+D16

And you should be all set.

Let me know if this solves your problem or not.

If not, please REPLY and let me know.

Else please go ahead and RATE this answer with SMILEY / 3to5 star ..

BONUS is always appreciated !

Take care,
Andy
Expert:  Andy replied 2 years ago.
Hi Stephen,

Make sure to format D17 as Number ... with no decimal places ... else the result will be 359.XXX ... so to remove the decimals and round it up ... make sure to keep no decimals ... if you don't know how to do this please let me know.

Let me know if this solves your problem or not.

If not, please REPLY and let me know.

Else please go ahead and RATE this answer with SMILEY / 3to5 star ..

BONUS is always appreciated !

Take care,
Andy
Customer: replied 2 years ago.

Andy,


 


My apologies, I am a little confused. Can you please check the attached excel sheet and confirm that I have entered the formulas correctly. I then need to create formulas for the two cells highlighted in yellow


 


http://wikisend.com/download/358658/Theodolite Pre Op Check.xls


 


Sorry to be a pest.

Expert:  Andy replied 2 years ago.
Hi Stephen,

The formulae that you have entered in D17 is perfectly correct.

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 next question.

Thanks and take care!
Andy
Andy, Computer Engineer
Category: Microsoft Office
Satisfied Customers: 23538
Experience: Experienced in all versions of MS Office Products.
Andy and 2 other Microsoft Office Specialists are ready to help you

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional
 
 
 
Chat Now With A Microsoft Office Technician
Andy
Andy
Design Engineer
21 Satisfied Customers
Experienced in all versions of MS Office Products.