# Convert Decimal Time To Hundredths

Aug 29, 2007
Have a large spreadsheet with time posted in minutes, but is formatted as "general" not time. (ie 8.15 is the entry in general format. Needs to be 8.25 to pay employee correctly). What formula can I use to convert that 8.15 to 8.25 easily?

View 3 Replies
ADVERTISEMENT
Jun 12, 2009

I am trying to convert time (formated as hh:mm) to a number with 2 decimal places.

Example

A1 7:51

B1 - want the number to show 7.85

Will then multiply this by an hourly wage to get total $ paid.

View 9 Replies
View Related
Sep 19, 2005

I need to convert regular time to decimal time. example regular time in A1

is 1:38 I need that number to be converted to decimal time = to 13:63. add

12 to the hour and divide 38 into 60 to get the minutes. Our time clock

prints on a 12 hour basis and I enter to excel in decimal time.

View 12 Replies
View Related
Oct 8, 2007

I need to separate a list of times from a telecommunications bill. I have 170,000 line of data.

The Times are represented as below.

eg

46 46 Sec

59 59 Sec

100 1 Min

159 1 min 59 sec

200 2 mins

502 5 mins 2 sec

1256 12 mins 56 sec

3456 34 min 56 sec.

How do I separate them to a decimalized per min value.

View 5 Replies
View Related
Apr 9, 2014

How to be able to convert decimal hours into time format.

Here are the examples:

12.2 = 12:02:00

98.41 = 98:41:00

300.42.1 = 300:42:10

and so on and so forth...

View 11 Replies
View Related
May 2, 2008

formulae that converts % into time and visa-versa.

I.e 1.5 hrs = 1.30 hours ( i.e 90mins)

or the other way round

1.30 hours = 1.5 hrs..

View 6 Replies
View Related
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
Oct 15, 2009

How can I format cells to contain Minutes, Seconds and Hundredths of seconds to be used in calculations eg 1.24.99 means 1 minute and 24.99 seconds. Example calculation is: 1.24.99 - 1.24.90 =0.0.09

View 2 Replies
View Related
Aug 8, 2008

I am trying to create a unique sample code by putting together the values of other cells that a user will input. It's all working well apart from the last part, where I am trying to include a decimal number. I want the decimal number to appear without the central "." and in a four digit format. e.g. 2.5 would appear as 0250, 14.25 would appear as 1425. This is the formlua I am using currently:

=IF(ISBLANK(B4),"",IF(LEFT(C4,1)="w",(B4&"-"&TEXT(F4,"YYMMDD")&C4&TEXT(G4,"HHMM")),(B4&"-"&TEXT(F4,"YYMMDD")&C4&LEFT(TEXT(H4,"00"),2)&RIGHT(TEXT(H4,"00"),2))))

However, where the value of H4 is 2.5, I am getting a result of 0303 (I've put this part in bold). I have attached a small spreadsheet to aid understanding.

View 2 Replies
View Related
Jun 12, 2009

I have this spreadsheet attached I'm trying to convert the time in col L to a decimal. I keep getting a #value error I have tried a bunch of formula's but it always the same error The report is generated off our AS400 network but it is in excel format?

View 2 Replies
View Related
Aug 22, 2014

i try to convert several decimal values into Days Hours:Minutes:Seconds my problem is the following. If i user the format DD hh:mm:ss values over 32 will start counting the days from 0 (like a new month). and if i format it like M D h:m:s values < 32 days gets displayed with a 1 (for the month) before the days.

[Code] ......

is there a way to get only the count of days displayed without the summarization to months?

View 4 Replies
View Related
May 31, 2006

I'm trying to find out how many 40 hour shifts we had in a week by dividing the total seconds staffed (2989957) by total seconds in a week (144000) to get a 2 digit decimal result. I have a field formatted as [s] that I need to convert to decimal but when I do a calculation using that field it comes out as [s}.

Cell A1: 2989957 formatted as [s]

Cell B2: =A1/144000 formatted as number with 2 decimals

Result shows 0.00

If I use that calculation in a cell with a general format, I get 21 and it reverts to [s] format.

View 2 Replies
View Related
Jun 24, 2009

I need to convert the fraction at the beginning of a cells text into the decimal equivelent. for example 1/4-20 3A would give .2500. I have this formula so far that works perfect for fractions that only contain 1 number on each side of the division sign such as 1/2.

View 2 Replies
View Related
Jul 8, 2009

Is there a method to automatically convert a decimal to a percentage?

For example:

if given the value of 76.48, is it possible to automatically convert this to 76.48%? Formatting the cell as a percentage produces 7648%. I've tried everything I know and can't get the right result.

View 2 Replies
View Related
Sep 4, 2009

I need a formula to take the numbers listed in cells D4:D50

If below 1,000,000 than just keep that number value

EXAMPLE DATA

If the Ten Thousands place is 5 or below leave the same if it is higher round up. (use this concept for ALL PLACE VALUES

1,500,000 to 1.5 million (if the rest are zeros)

4,000,000 to 4 million

1,564,535 than to 1.57 million

1,545,535 than to 1.54 million

1,555,000 than to 1.55 million

Same concept for the rest as the Millions (move the rounded place up as needed)

So for Billions it would be 10 Millions place (to round form) I think lol

1,000,000,000 to 1 Billion

1,500,000,000 to 1.5 Billion

1,560,000,000 to 1.57 Billion

1,578,000,000 to 1.58 Billion

1,700,000,000 to 1.7 Billion

I would like this to continue all the way up to place value 999 QUADILLION! (if possible) if the value can go bigger that would be great!

View 9 Replies
View Related
Aug 11, 2008

I was reading this Binary Conversion from Decimal on this site, however i am unable to reply to the thread. This code is exactly what i was looking for but have the need for it to be able to give the result as a number of bits eg. i would like the result to be dispalyed as 13 bits. I have tried modifying the code without any success and would like to be able to use it in this form. Public Function Dec2Base( Num As Long, base As Long, length as long) As String

View 3 Replies
View Related
Sep 2, 2009

I got following Hex data in text format, I need change them to decimal,

0324 00BF 0000 0000 030C 00C6 0000 0000

0305 00C7 0000 0000 02FE 300F 040B 4753

4D4D 5352 4E4D 5343 4E31 0030 0F0A 0101

firstly I did txt to columns, then I found some data changed to scientific format which is not I wanted as I could not convert it using function HEX2DEC.

032400BF00000000030C00C600000000

030500C70000000002FE300F040B4753

4D4D53524E4D53434.00E+3100300F0A0101

if I set column data format to text when I doing Text to Columns operation then all data will be text, so I still can not convert them to decimal.

View 4 Replies
View Related
Feb 16, 2006

Is there a way to convert a value in a cell that is 2'-3 1/2" to adecimal such as 27.5"?

excel 2003 SP2

View 14 Replies
View Related
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
Aug 29, 2007

How to I convert minutes into the equivalent fractional hours?

View 9 Replies
View Related
Aug 16, 2008

I've got a time difference from 8:00AM - 12:30PM as 4.30 I'm trying to get the minutes, .30, converted into a 6 minute increment, .5. Is it possible to do this and if so how would it be done? Below is a chart of how the time is converted from 6 minutes increments into decimal form.

6 = 0.1 36 = 0.6

12 = 0.2 42 = 0.7

18 = 0.3 48 = 0.8

24 = 0.4 54 = 0.9

30 = 0.5 60 = 1.0

View 5 Replies
View Related
Feb 6, 2009

I know that if I enter =3/4 in a cell it will give me .75 but is there is formula to convert fractions into decimals or is this the best way to do it? I was also wondering if there is some way to convert the decimal amount to a fraction

for measurement conversions I know that

=B3*25.4 will convert a decimal to mm and so will the formula =CONVERT(E4,"in","mm")

and to convert mm to a decimal a few formula that work are

=CONVERT(H3,"mm","in")

=MROUND(H4/25.4, 1/8)

=H5/25.4

=INT(H6/25.39999918*8)/8

But is there a way to convert a fraction to the decimal and is there a way to convert mm to a fraction instead of the decimal equivalent of the fraction?

or maybe a formula to convert mm to inches but instead of the result being in decimal format it would be in fraction format?

View 4 Replies
View Related
Mar 17, 2014

I am trying to convert 14 to 15 digits lengthy Binary value to number.

The formula =BIN2DEC(A2) is giving error #NUM

101111100001010

101111100001010

101111100001010

101111000011100

101111000011100

101111000011100

110001000001010

View 2 Replies
View Related
Oct 29, 2002

Is there a formula to convert a Decimal location into D/M/S form for Lat and Long

View 9 Replies
View Related
Mar 19, 2013

I need to be able to convert big hex numbers into decimal numbers. The problem that I have with this is that when you put a hex number that includes letters excel considers it text. And if the number is too big, you can't convert it to decimal format, and when you try to, it comes up with the #NUM! error.

Number: "78652385098375A879FF747C9847A00" without quotes

View 4 Replies
View Related
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
Aug 14, 2007

i wanna convert the decimal number to a round number...like 2.0L to 2L.

View 6 Replies
View Related
Dec 16, 2007

i have a combo boxes populated with fractions 1/16, 1/8, 3/16, 1/4 etc up to 15/16.

i just want to output the chosen fraction to a textbox as a decimal.

This is done in a userform, not in a cell.

View 9 Replies
View Related
Feb 3, 2010

I was messing around with a simple countdown timer and need a little help converting a decimal into a format of #days, #hours, #minutes and #seconds.

Cell A1 has target to countdown to 4/14/2010 12:00:00 AM

Cell A2 contains =NOW()

Cell A3 contains =A1-A2 with the result being 69.4021441 with the amount of decimal places varying depending on when it is refreshed.

I'd Like the result in A3 to read something like "There are 69 days, XX hours, XX minutes and XX seconds until event"

View 10 Replies
View Related
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