Decimal Related Problems & Solutions

63 tags
Refine Tags
Search Tags:

Results 1 - 30 of 63
[Solved] Example of decimal to hexadecimal
Summary: An example of decimal to hexadecimal A shortcut method. Two methods. One being less than 255 (Dec). Two being more than 255 (Dec). (1) 110 example num...

[Solved] display in scientific notation
Summary: How do I switch between decimal and scientific notations for the calculated answer in the real calculator app for android? For example, I calculated ...

[Solved] open off ice how to have \$40 show up as \$40.00.enter drops00
Summary: In open ofice Calc I want my \$40 to show up as \$40.00 and when i ENTER IT reverts back to \$40. I am assuming this is a decimal point setting that I am...

[Solved] MAC address EC_DD_FE_E8_76_12 into a decimal
Summary: I can't figure out this MAC address into decimal form? I've looked through all of my computer books that I've gotten over the last three years, to no ...

If (value is an integer, return value, otherwise 1)
Summary: Some entries in items column include decimal points (i.e. sold by weight) I need to sum the column, BUT all values NOT an integer need to be counted a...

how can i calculate duty hours
Summary: how can i convert hours in decimal number. I want to calculate my employees daily work hours and also calculate the daily amount per hours. What metho...

[Solved] User entered 23:59 as 23.59, need to convert back to 23:29
Summary: Excel User entered 23:59 as 23.59, need to convert back to 23:59, so that I can convert back to correct decimal eg.. Correct Result for 23:59 is 23....

[Solved] Convert hh:mm to decimal number in excel
Summary: Im using an excel spreadsheet with clock in and out times in hours and minutes (hh:mm). I want a formula and formate to add up the total hours worked ...

[Solved] Turn off rounding in excel
Summary: Resultant of division display zeroes after the decimal where there shoud be integers. True value > \$4.42 true value > \$28,812.95 sum by formula > \$28,...

can i use as like =IF(F100.25,MROUND(F10,0.5),0)&IF(F100.2
Summary: =IF(F10>0.25,MROUND(F10,0.5),0)&IF(F10<0.25,MROUND(F10,0.25),0) is it RIGHT? Can I use this like formula which brings decimal saperation ...

[Solved] comparing Decimal number's in unix shell script
Summary: Hello, I'm stuck on this issue where i need to compare Decimal number's in unix shell script. Example: Want to compare file versions version of "File1...

[Solved] Convert number to time to decimal time in Excel
Summary: I have an Excel cell (general format) with the number 7.40 in it. It's supposed to mean 7 hours, 40 minutes. I need to multiply what 7.40 really mea...

how do i convert 2:30 into 2.5
Summary: how to convert 2:30 into 2.5 decimal time? I have the formula =IF(C8<B8,C8+1,C8)-B8 A8 B8 C8 D8 thu 12:00 PM...

round and if excel function
Summary: I want to make formulas for conditions :that if ratio of two(I4,J4 for example) is <0,2 than report<0,2, otherwise take the result into account,...

[Solved] Conversion from Bottom-up to Top-down design...
Summary: I have a trouble in converting bottom-up program to top-down. # include <stdio.h> # include <conio.h> # include <stdlib.h> int main() { int m...

I want to listed data in two decimal places
Summary: I work with MySQL Database and VB6 SELECT format(Prevtaksi,2) FROM tov_adm Where Prevtaksi is not null the result is like 2,345.88 and this is ch...

from arithmetic to excel
Summary: sqrt(44²+45²)-1=61.93648 if>53then-53if decimal round up I need to write this in excel. for example I have A1=44 A2=45 all results must be less or i...

Hours & Minutes to Hourswith Decimal
Summary: Hi guys, I have a solution to a large timesheet calculation formatted as [h]:mm Is there any way to format this as strictly hours? i.e. if the solu...

my excel isnt calculating correctly.
Summary: my excel isnt calculating correctly. i know it sounds odd but its true. im doing some simple spreadsheets too. one is a payroll sheet, the other one i...

Turn rounding feature off in Excel
Summary: I need to know how to turn off the "rounding up" feature in Excel 2010. For example...if I don't want 25.50 to round up to 26, how do I stop that fro...

Dos conver value to number
Summary: Hi, I have to convert the value '08 '(current month) in number. example: rem choice /T 30 /D y SET DSIST=%DATE%-10 SET NDATA=%DSIST:~6,4%%DSIST:~3,2%%...

date format from mm/dd/yyyy to yyyymmdd
Summary: I am trying to take one xl sheet to unix database. Presently the date field contains mm/dd/yyyy where as the format should be in yyyymmdd to fit in un...

how to change dates to text in excel for merg
Summary: I need to do a merge with just the month and date spelled out as such "November 8" . I figured out how to format the text to say "November 8" but it...

how to make a program that accepts input numb
Summary: Pls help!!!how d o i write a program that accepts input number & display its equivalent roman numerals Input:565 Output; DLXV limit is 3,000 ...

Need to concatenate a time cell with another
Summary: I have 2 cells that I need to join. Example: A1 = MR and B1 = 9:15 AM - I need C1 to have MR - 9:15 AM I keep getting MR - 0.38541666666 ...

unle chnge dt format 25.01.2011 to 1/25/11 fo
Summary: unable to chnge date format 25.01.2011 to 1/25/11 by using formula in excel 2003 ...

excel 2011 mac 'sum formula' returns zero
Summary: It will add intergers, but not decimal numbers i.e. =sum(0.5+0.6) results in 0,00 ...

Excel 2007 - Value Comparision
Summary: I want to compare two cells that have a formula in them. If the values are equal I want it to be 0.5. If the first cell is larger than the second I wa...