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


ADVERTISEMENT

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

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

UDF For Converting Seconds To Hours And Minutes

Jun 6, 2014

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

View 2 Replies View Related

Days, Hours, Minutes And Seconds

Sep 23, 2008

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

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

Adding Seconds And Minutes To Get Hours And Days

Nov 13, 2006

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

View 9 Replies View Related

Format Time To Show Hours, Minutes & Seconds

Jul 6, 2007

is 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 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

Time Difference In Hours / Minutes And Seconds Between 2 Date / Timestamps

Aug 22, 2012

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

View 2 Replies View Related

Cell Formated To Show Days, Hours, Minutes, Seconds

Apr 1, 2009

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?

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

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

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

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

Converting From Seconds To Minutes?

Feb 6, 2013

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

I have problem in converting from seconds to minutes.

View 1 Replies View Related

Average Minutes And Seconds

Nov 20, 2009

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.

View 2 Replies View Related

Fx To Calculate Seconds From Minutes

Sep 24, 2007

=(((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.

View 14 Replies View Related

Converting Minutes To Seconds

Jan 3, 2007

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

Extract Minutes And Seconds From A Time Value

Oct 20, 2009

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.

View 2 Replies View Related

Calc Minutes And Seconds Difference

May 27, 2006

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

View 12 Replies View Related







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