Convert Excel Decimal Total To Minutes And Seconds

May 6, 2008

I have listed a total amount of timings for a study that I have totalled giving me a figure of 34.76 which is under an hour.

how do i convert to min and seconds - is there a formula?

View 9 Replies


ADVERTISEMENT

Convert Decimal Minutes & Seconds To Total Seconds

Sep 23, 2007

How can I Convert Decimal Minutes & Seconds To Total Seconds?

Here is the sample

View 4 Replies View Related

Convert Hours, Minutes And Seconds Into Total Seconds

Jun 28, 2008

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.

View 5 Replies View Related

Convert Decimal Minutes & Seconds To Days & Hours

Dec 2, 2006

I have two columns A and B. Column A contains problem title and column B is duration minutes. In column B we enter always min and seconds it took us to resolve certain issues (22.15 = 22 minutes and 15 seconds) . At the end of the month I need to run a report for my manager to show her by problem title how long it took my group to resolve issues and it should output as Hours/min/days.

View 5 Replies View Related

Convert Decimal Degrees To Degress, Minutes & Seconds

Sep 16, 2007

Need to convert decimal degrees into degrees, minutes, & seconds (displayed in three columns). Currently calculated manually from ATAN, ASIN, or ACOS functions.

View 4 Replies View Related

Convert Decimal Value Into Total Seconds

Jan 24, 2010

I have a formula that reads like this

=((11.4)-0.000000000946727*(11.4)*((5000)*5000))

The formula is used to calculate a comparative run time at an elevation of 5000 feet. The time the run was in is 11 minutes and 40 seconds. What I need to do is convert the 11.40 into total seconds which would be 700.

Now the actual 11.4 in the forumala is from a cell reference (say D14). It's whatever time the member plugs in (and so is the 5000, this represents the members altitude).

I need the time to stay in a decimal format because I have a huge database that I perform a lookup on to find the point value for it for another calculation seperate from this one. If I were to plug 700 in place of 11.4 my calculated result would be 683.43 which is exactly what I need.

View 3 Replies View Related

Convert Decimal Degrees To Degrees / Minutes And Seconds

Sep 16, 2007

Need to convert decimal degrees into degrees, minutes, & seconds (displayed in three columns). Currently calculated manually from ATAN, ASIN, or ACOS functions.

View 5 Replies View Related

Convert Decimal Degrees To (DMS) Degrees Minutes Seconds

Nov 17, 2006

how would you take decimals to dms, and also how to put dms into the right bearings?

Reference: Covert degrees, minutes and seconds to decimal degrees

View 4 Replies View Related

Convert Days:Hours:Minutes:seconds To Minutes?

May 25, 2011

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.

View 4 Replies View Related

Convert Seconds Into Hours:Minutes:Seconds

Jun 18, 2008

Is there an easy way of converting seconds from using a time into hours, minutes, seconds

View 9 Replies View Related

Hours:minutes:seconds Convert To Seconds

Jul 13, 2006

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.

View 9 Replies View Related

Convert Seconds Into Hours, Minutes & Seconds

Dec 7, 2007

I have a spreadsheet that imports data relating to phone call durations. The information imports as a total number of seconds taken.

What I need to do is to change that number of seconds into hours, minutes and seconds.

Changing the format of the cells doesn't work.

I've tried everything I can think of, and run out of ideas.

example:

23 needs changing to 00:00:23
96 needs changing to 00:01:36
268 to 00:04:28
9374 to 02:35:14

View 7 Replies View Related

Change Decimal Minutes Into Seconds

Oct 10, 2012

I am looking for a simple formula to change decimal minutes into seconds for example 0.12 = 7 seconds

View 3 Replies View Related

Converting Decimal Numbers To Minutes And Seconds

Jul 27, 2009

I have an excel sheet with a row of numbers example below. These numbers represent the length of time that a telephone call was. The problem is they are decimal numbers (units of 100) but they represent seconds and minutes of a phone call which change up one number when the seconds hit 60 ...

View 9 Replies View Related

Convert Decimal Hours And Minutes To Minutes

Jul 4, 2006

What formula will convert 4.50 to 530 minutes ( "Decimal Time" )

another example 16.50 to 1250 minutes.

View 13 Replies View Related

Convert Hours To Minutes And Seconds

Jan 8, 2007

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?

View 10 Replies View Related

Convert Number To Minutes And Seconds

Jan 30, 2012

I have 36 minutes and 40 seconds entered as 36.4 (General Format)

How do I convert this to an actual time format mm:ss

View 2 Replies View Related

Convert Hours To Minutes. Display Total Minutes

Dec 5, 2006

I have a formula which will calculate the number of hours and minutes between two military times. I would like it to calculate the total number of minutes instead of hours and minutes. I have uploaded a small example of what i have so far.

View 3 Replies View Related

Convert Minutes Into Decimal Hours

Aug 29, 2007

How to I convert minutes into the equivalent fractional hours?

View 9 Replies View Related

Convert Degree Minutes And Second Lat And Long To Decimal

Jun 12, 2013

I'm trying to convert degree minutes and second latitude and longitude to decimal lat and long in excel (I have 100s of such conversion to undertake). When trying out dividing the minutes and second by 60 and checking my calculation on Google Maps lat/long finder or Latlong.net my calculations are not correct. However the equation to other way around - converting from decimal lat long to DMS (*60) works.

View 2 Replies View Related

Convert Decimal Numbers (Minutes) To Time Format

Mar 8, 2013

How to convert decimal numbers which represent minutes into time format? Like this

Sheet3  GH1MinutesTime212.9729729700:13:00325.9459459500:26:004116.756756801:57:00

View 2 Replies View Related

Converting Minutes, Seconds And Tenths Of Seconds Into Seconds

Jan 18, 2010

I want to change 1 minute 24 seconds and 5 tenths into a seconds number. So basically it would come out as 84.50 seconds.

View 4 Replies View Related

Decimal Degrees To Degrees Minutes And Seconds

Dec 9, 2008

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: ....

View 9 Replies View Related

Excel 2010 :: Formatting Minutes And Seconds?

Apr 17, 2013

I have a sheet where staff enter the time it takes to do a task. I'm using a custom format of [mm]:ss. However, I enter (for instance) 5 into the cell, the value becomes 7200:00. I finally figured out that this is because that is the number of minutes in 5 days. However, I don't want staff to have to enter 00:05:00 to indicate they worked for 5 minutes. I would rather them be able to enter something like 5:30 (or something along those lines) to indicate this took 5 minutes and 30 seconds.

View 1 Replies View Related

Convert Time Range To Total Minutes

Feb 25, 2009

I have the following time ranges that need to be converted into total minutes. Examples (from easiest to most difficult)...

The items below are in column A (each range is the content of just one cell):

00:00-13:00
06:30-13:15
13:30-13:15 (this spans two days, so it's actually 23H and 45M)
23:30-03:00 & 16:00-22:10 (only the first time range matters; the second can be omitted)

So for 00:00-13:00, we have 13H and 0M = 13 * 60 = 780. And for 23:30-03:00, we have 3H and 30M = 3.5 * 60 = 210. But how do I automate this process with the text entries above (and hundreds more that are imported in this format).

View 9 Replies View Related

Convert Total Time To Days & Hours, Minutes

Apr 24, 2008

I have a column of tasks that take a certain amount of time to complete formated as h:mm:ss. I want to total the column and convert the total to days, hours and minutes. Is that posible and if so how do I configure a formula and format the cell? example:

task 1 54:00:00
task 2 20:45:00
task 3 27:05:20
task 4 51:10:45
total 153:01:05

How many days, hours and minutes?

View 6 Replies View Related

Convert Degrees Minutes & Seconds To Degrees.decimals

Nov 1, 2008

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:

=+IF(A2<>"",INT((LEFT(A2,3)+MID(A2,4,2)/60+MID(A2,7,4)/3600)*100000)/100000&"d","")

View 7 Replies View Related

Converting Seconds Or Minutes:Seconds To A Number

Jun 21, 2009

How would I go about converting - for example:

0:22 (formated general) to a number = 22

or

1:30 (formated general) to a number = 90

View 9 Replies View Related

Converting Seconds Into Minutes And Seconds?

Jan 29, 2013

I have been trying for the last two weeks to convert a list of seconds into minutes and seconds, but just can not do it?

Below is an example of my raw data, that I need to convert into minutes and seconds:

120000

120000

120000

2880000

480000

[code].....

View 5 Replies View Related

Changing Minutes To Seconds

Nov 24, 2009

i need a hand to change the following. how do I get 02:23.5 ( Mins, seconds, 100th of a second) into just seconds.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved