# Converting Minutes, Seconds And Tenths Of Seconds Into Seconds

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

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.

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

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

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

Here is the sample

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 RelatedIs there an easy way of converting seconds from using a time into hours, minutes, seconds

View 9 Replies View RelatedI 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 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

I am working on Degree,minutes and seconds & I am using macros.

I have problem in converting from seconds to minutes.

I have a spreadsheet that I need convert times from minutes to seconds. Such as 03:44 minutes to 224 seconds.

View 9 Replies View Related[URL].....and the answer worked really well; up until a point of

Total Seconds32767

Time From Seconds09 hrs 06 minutes(s) and 07 second(s)

any higher than this value brings a #value error.

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 RelatedHow do you format

Second(Now)

to display tenths, hundredths, or thousands of a second? Must be in code since it will never be applied to a cell.

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

View 2 Replies View Related=(((60/3600)/24)/X)+A1

I have to manually enter X based on the number of times the time stays the same before going on to the next minute.

12:01

12:01

12:01

12:01

12:01

12:01

12:01

=(((60/3600)/24)/7)+A1

I would like to automate the above so that X is caculated, however ; X can be any number from 1 - 25 and is completely random.

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 RelatedI 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?

Does any know how I can convert 29.18:20:18 to total minutes?

View 7 Replies View RelatedI 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.

A1 (8:52, m:ss) - A2 (8:40, mm:ss) should = 0.12 (12 seconds)

Presently I am using the following: =TEXT(A2-A1,"h:mm:ss"), I only want to

display m:ss, hours are meanlingless

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

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

View 3 Replies View RelatedIn a column range, i need to enter sequences of minutes and seconds as follows:

12:08

13:19

16:49

28:13

I had changed the format of cells to mm:ss but if i enter 12:08 excel shows it as 08:00 unless i enter it with the hour (00:12:08)

Is there any way to avoid entering the hour each time but simply minutes and seconds?

is there away to format a cell to do minutes and seconds? then get an overall sum?

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.

I currently have a lot of times saved in an excel file that are in seconds for example 245.9 seconds. Need formula where i could have in the next cell to it where it would say 4 minutes 5.9 seconds.

View 2 Replies View RelatedI have a column in excel which includes numbers like (12 13 14.5), and I want to format like this (12 Degree Sign, 13 Minute Sign, 14.5 Second Sign).

View 9 Replies View RelatedI 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 RelatedI am trying to add duration time for song files. 4 minutes and 32 seconds + 3 minutes 45 seconds, etc. etc. to get total hours and then to total to days. The range of cells is over 5,000 and I am trying to find out how long a playlist will play.

I have the below macro. It is used to translate time to seconds (i.e. 0:20:04 minutes to 1204 seconds)

This works well, but i just want to know 3 things.

First, can the new data (seconds value) be added to new worksheet (worksheet 4) of the workbook the original data is taken from, instead of a whole new workbook?

Second, can this be done without having to save the original workbook first?

Third, (Im sorry i know this is VERY simple) but this macro is part of a larger macro, and i just want to know the code to hide the screen updating as the macro is running.

Sub Refresh()

Columns("A:A").EntireColumn.Select

Application.CutCopyMode = False

Selection.TextToColumns Destination:=ActiveCell, DataType:=xlFixedWidth, _

FieldInfo:=Array(0, 4), TrailingMinusNumbers:=True

End Sub.........

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.

View 2 Replies View RelatedI 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?

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 Relatedis there a way in VB to make it fast, and tidy, clear the contents of all unlocked cells on one sheet ?

View 2 Replies View RelatedNeed 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 RelatedI have an ACD program that gives me a time in "mm:ss" format, or in ":ss" fomat. I have 2-3 problems with charting this data.

1 I am inheriting the production of charts from someone else, with old data being displayed by seconds only I am supposed to keep this display.

2 the data that is in mm:ss format is recognized as being in full date format, for example 2:14 is recognized as 2:14:00 AM instead of 2 minutes, 14 seconds.

3 the data that is in :ss, ie :44, is recognized as a string.

Any thoughts on how I can convert both cases to a integer seconds? I know for example that I could mid() the second condition, but I am stuck thinking about the first condition.

I can't adjust the way the time comes in, unfortunately. It is an auto-generated export of the data from a switch.

I have very little experience with Excel. What I am trying to do is to convert a timecode in this format 00;22;21;00 that is 22 min 21 sec and 00 frames to a serie of numbers that I have hard time to figure out. Example

00;22;21;00 = 13410000000

I want to be able to paste the timecode from premiere 2.0 (00;22;21;00) into a Excel cell that would automaticly convert it to (13410000000) so that i can eventualy generate a .txt file that would look like this:

<Scripts >

<Script Type="URL"

Command="http://www.softfx.com/slide01"

Time="13410000000" />

</Scripts>

I have

Code:

Start date 21/08/2012 23:21:30

End Date 24/08/2012 22:21:45

is there a formula to get the time difference in Hours for example in this case its 72:01:15 72 Hours, 1 minute & 15 seconds

I have a fairly simple macro that takes a few seconds on my XP-computer with Excel 2003 but takes several minutes on my Vista-computer with Excel 2007.

The XP-PC has 2GB memory, the Vista-PC only 1GB, but it's hard to believe it's only that.

Is Excel 2007 so much slower than 2003?

The macro makes quite extensive use of the .rows(Rownr).Delete method. Is the fact that 2007 has 1 million rows against the 65536 of 2003 the culprit? It has to shift much more data up when deleting a row, no?

I have the foollowing equation in a cell:

=NETWORKDAYS(A2,A12)+G12

My answer is 1081:23:42.

Is there a way to have it show the number of days, hours, minutes and seconds? So it will say 45:1:23:42? (45 days, 1 hour, etc...) Or something along these lines?

ADVERTISEMENT