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 RepliesHow can I Convert Decimal Minutes & Seconds To Total Seconds?
Here is the sample
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 RelatedHow 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].....
I am looking for a simple formula to change decimal minutes into seconds for example 0.12 = 7 seconds
View 3 Replies View RelatedI 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 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 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 RelatedNeed 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 Relatedhow 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
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 to convert decimal numbers which represent minutes into time format? Like this
Sheet3 Â GH1MinutesTime212.9729729700:13:00325.9459459500:26:004116.756756801:57:00
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
we work with both Lotus 123 and Excel 2003. Lotus will be gone next year, but for now, the official mean to publish our reports is Lotus. With my work, I copy/paste a Lotus page to Excel. I use the following macro to convert Lotus format numbers (which Excel considers as text) to real numbers:
Sub ForceToNumber()
Dim wSheet As Worksheet
For Each wSheet In Worksheets
With wSheet
. Range("IV65536") = vbNullString
.Range("IV65536").Copy
.UsedRange.PasteSpecial xlPasteValues, xlPasteSpecialOperationAdd
End With
Next wSheet
End Sub
Source : http://www.ozgrid.com/forum/showthre...087#post184087. The problem is that I need to send back this data in Lotus. Excel considers decimal numbers with a coma as real numbers and numbers with a dot as a text. This previous macro fixes that. However, Lotus works the other way. Only numbers with a dot are considered real numbers. So I would need to find a way to code a macro that converts any numbers in the Excel sheet to a number with a dot. It's a bit like doing the opposite operation.
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 RelatedWhat formula will convert 4.50 to 530 minutes ( "Decimal Time" )
another example 16.50 to 1250 minutes.
creating a formula for converting time data that has been created in an excel spreadsheet in minutes i.e. 516 minutes which I need to turn into Hours and Minutes i.e. 08:36 I am not experienced using Formulas, apologies if this question has been posted before, I did use the search facility to look for threads, but could not find anything related
View 5 Replies View Relatedi 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 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.