Working On Sheet That Uses GPS Position (Degrees / Minutes / Seconds)
May 29, 2013
The problem I am having is in trying to make a custom cell format for inputting my data. I want it to appear as 44° 41' 5" (in the same cell). I would like the cell to function so that if im inputting data manually for it to automatically put in the appropriate (degree,minute or second marks). That way I could just enter somthing like 44 41 5 and it display properly. Also I am trying to keep the data in text format for another marco I am running to convert the DMS data into decimal.
Need to convert decimal degrees into degrees, minutes, & seconds (displayed in three columns). Currently calculated manually from ATAN, ASIN, or ACOS functions.
I had a similar problem a day or two ago in converting Deg Min.dec to Deg.dec and it has happened again. This time I want to convert Degrees Minutes & Seconds to Degrees.decimals.
The formula I am using works for a two digit number Lat. but not 3 Long.?? Here it is below:
I've writing excel formulas to convert Decimal Degrees (DD) to Degrees Minutes and Seconds (DMS) and back again for astronomy. These are for converting DD angles for telescope Right Ascension (RA) and Declination Angles (DEC) pointing.
I've got the formulas to work except for one minor annoyance. Try this formula for converting DEC DD angle of -1.5° to a DEC DMS angle: ....
How do I custom format a cell to display degrees minutes seconds. I now there is a way. I found in on the web once but can not find it again. The formating from cpearson does not work the way i want.
For example if in cell a1 I input 50.2536, I want to to format the cell as 50° 25' 36". opefully this can be applished without any formulas. Either soem code or formating would be great. The last time I found it I thought it was something like ###° ??'/??" but that did not work. Thanks in advance. The reason I need it, is to use the convert_decimal function I found on the microsoft website.
Need to convert decimal degrees into degrees, minutes, & seconds (displayed in three columns). Currently calculated manually from ATAN, ASIN, or ACOS functions.
I am trying to convert Degrees Minutes & Decimals of a minute (12° 34.567') to Degrees and decimals of a degree (12.57611°). I have the formula to convert latitude, that is two digits, but it doesn't want to work with longitudes, three digits. (see attachment). This is the formula that I am using:
I trying to figure a formula to convert time on a phone call eg. 01:01:21 into total seconds (3661). Phonecalls will never be more than an hour long but the spreadsheet I will be supplied with (havn't got it yet!) will display them in the 00:00:00 format.
I am trying to convert a number of "hours" "minutes" and "seconds", to give me a result in seconds only, in order that I may then financially cost the amount of time spent on a task. (A time and motion costing exercise)
Example:
1119:48:06 Represents 1119hours:48minutes:36seconds spent on a task.
I can manually convert this to 4031286 seconds, but it just takes too much time !!!(sorry!)
The data is extracted from a database which is unable to split the hours,minutes,seconds into seperate fields, which prevents me from using three cells in excel.
I have a spread sheet with a colum showing average time to complete a task. This is currently shown as Days:Hours:Minutes:Seconds (4:19:33:19). I meed it to be shown purely as minutes, or at least as hours and minutes.
I have some time data that is dumped into an excel file from a phone system. I'm trying to average the data, but I get division by zero errors. The data is originally formatted as "general" and when I convert it to a time format I still get the error. I've attached a small version that has just the time column.
I am trying to use the Mod function to convert the following:
I have time in hours in A1 as 12.66 and I need it to convert to 12 hours in A2, 39 minutes in A3, and 36 seconds in A4. What formula can I use to achieve this?
I have a formula that gives me a time value (ie 12:53). I need to perform another formula that will use this data but I need the numbers seperated (12 in one cell and 53 in another)
In essence, what would be the formula to pull off the minutes number and the seconds number into individual cells. I know anything is possible in Excel, I just can't figure this one out.
Spreadsheet tracks race times for cross country races and needs to be able to calculate improvement time in mm:ss (or zero if less than previous race).
Also,it would be nice to be able to enter times without using colons or have to reference the field as h:mm:ss. The race result will always be mm:ss and the last two digits will always be seconds, the result will never be more than 60 minutes so hours are a real bother.
