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

**calculate valid addresses for hosts** *Summary*: for network 192.168.7.128/26 what is the first usable host IP address in decimal? What is the last usable host IP address in decimal? ...

**i want logic to convert hex into bcd** *Summary*: i just want simple logic behind converting a hexadecimal no. into bcd.... like the way we convert a decimal into binary by dividing decimal by 2 n tak...