Need formula that would convert grams to lbs,ozs and drams. I know that grams to drams is *0.564383391193 then divide by 256 to lbs but don't know now how to deal with the non full numbers
View 9 RepliesI have the records of a local angling club going back to 1932 and these records include the results of fishing matches matches held through that period. I want to analyze the catches of those matches in order to identify any trends that may exist on the river that those matches were fished and although I am reasonably computer literate I have never needed to use spread sheets.
If the data from those records were in metric measurement it would be no problem but they are in what I would refer to as Imperial measurement.
In other words they use measures in weight based on Pounds, Ounces and Drams.
There are 16 Drams in an Ounce and 16 Ounces in a Pound.
The software that is on my computer is Microsoft Excel Version 5.0c
I want to sum a weights using grams, for example: 457.35.21 with such other numbers.
457 represent Kg
35 represent g
21 represent part of the g
I have an excel workbook that has a column called Weight in LBS. I already have about 7000 products all shown in pounds. Im switching to a new program that requires the weight be shown in grams! Is there any way of converting all of my existing rows to show as grams? They are all different weights, some less than a pound all the way up to 20 pounds!
View 7 Replies View RelatedI've taken on an old excel datasource any I need to restructure it and a column is foxing me.
The column lists time in mm.ss format (decimal seperator), so 1.5 hours is shown as 90.00. For future use, I need this column to be formatted in hh:mm:ss (colon sepertors), ie 1:30:00
If I simply change the cell format to hh:mm:ss,
I am trying to save a file from xls to csv. One of my columns in the xls file is filled with numbers separated by commas but is saves as a text. Whenever I save the file as a csv it converts the numbers saved as a text to be saved as numbers so it screws my commas up and therefor messes up the entire file.
View 10 Replies View RelatedI am using the function =LOOKUP(J2,Sheet4!$A$2:$A$1000,Sheet4!$B$2:$B$1000)
which sometimes returns a #N/A error. I want it to return an empty cell instead in those cases. My attempt was =IF(LOOKUP(J2,Sheet4!$A$2:$A$1000,Sheet4!$B$2:$B$1000)=NA(),0,LOOKUP(J2,Sheet4!$A$2:$A$1000,Sheet4!$ B$2:$B$1000)) however, it still returns a #N/A error. Is there any way around this?
I have a rather large "application" that I've built into a spreadsheet at work (about 1200 lines of code, 4 forms, and code on a few spreadsheets).
I'd like to convert all this code and the forms into a VB6 project so I can have this application as an executable separate from the workbook, if possible.
I tried exporting the forms, but they show in the project explorer as Designers.
how can I creat a formula say to convert a time (mm:ss) to seconds (ss) only. Is that possible? And how do I do it.
I got a column say of these values and I want whats after "="...
3:07 = 187 sec
1:10 = 70
5:16 = 316
1:25 = 85
5:40 = 340
I have 2 weeks of data that I need to convert the Average handle time to seconds only. All the data is in 30min invertals for a full 24hr day.
A1 = USD$100, I want C1 = 100, What is the formula for C1,
View 9 Replies View RelatedDoes anyone have a simply way to convert UST time to EST.
Keeping in mind that we use military time format.
When coding my macro to stored to .csv file I encounter a problem.
Buildup file:
Row A: has 24 columns with header info
Row B: has 15 columns with header info
Row C: has 9 columns with header info
Row D: has 24 columns with record info
Row E: has 15 columns with record info
Row F: has 9 columns with record info
Row G: has 24 columns with record info
Row H: has 15 columns with record info
Row I: has 9 columns with record info
etc...........
I have times in 24h clock format and want to change to 12h so 18:00 will look like 06:00 see attached for actual formats
View 10 Replies View RelatedI am trying to convert a row with cells referring to other cells (or with formulas in them) into columns, but paste special - transpose does not do the trick; the reference somehow changes when I try to paste it in, say A5 in the example file. I have excel for mac.
View 2 Replies View Relatedi 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?
I am trying to convert cells so that I can pull data into a pivot to only show month & year. I have connverted the format in the cells to custom mmm-yy in the source data w/sheet which displays it how I want it to but the pivot table also picks up the day so instead of having groupings by month/yr I am getting groupings by day/month/year.
View 2 Replies View RelatedHow to convert the excel formula into its value? I know the easiest way is to copy and use paste special then "value" options but is there a way to make it automated in case the desired output value has resulted.
HTML example:
A1 B1 C1 D1
1 2 A1+B1 Yes/No
on the above example, if D1=Yes, the output C1 will become value equals to 3 and the formula will be remove, if D1=No, the formula will still remain.
I have a lon list of dates in the format dd/mm/yyyy. I can change the format to DDD to show the day of the week. What I want to do though is make that permanent, not just in the format.
View 4 Replies View RelatedWhat is the Easiest way to Convert this Date and time format into Dates Format i.e MM/DD/YY
View 5 Replies View RelatedHow do I get a straight conversion from h:mm to h:tenths? As soon as it hits 23:59, the clock start over in the tenths column. ie...39:27 should read 39.4. I'm currently using this formula: =(T10-INT(T10))*24
3:283.5
8:508.8
9:269.4
10:4210.7
12:5712.9
14:1214.2
39:2715.4
41:4217.7
59:5711.9
how to convert .xlsx file into .csv?
View 4 Replies View RelatedI have a list of date and want to convert those date to day name.
1-Jan-10
2-Jan-10
3-Jan-10
4-Jan-10
5-Jan-10
6-Jan-10
7-Jan-10
8-Jan-10
9-Jan-10
10-Jan-10
11-Jan-10
12-Jan-10
13-Jan-10
My question is i have use simple sum function and want to total of sum show in text another range as like 1400 Rs FOURTEEN HUNDRED ONLY
View 1 Replies View RelatedIs there a way to convert a csv file to an xls file without using any software.
View 4 Replies View RelatedHow Do You Convert PDF Files Into An Excel File?
View 1 Replies View RelatedI need a user defined function meaning a code to convert this
101206 to 10/12/06
I'm just trying to get a total of columns E, F and G, and place those totals in row 5. The problem is that somehow the numbers in column G were stored as text, so the SUM formula is coming up "0". How would I format these cells, in a macro, (columns E, F and G, just in case the data in the other two columns were stored as text), as a number so that I can total them.
I've tried selecting the column, selecting format cells and choosing number, but that doesn't work. I can manually select the cells, click the little exclamation point, and then tell it to convert to number. This works, but when I tried to record it to add it to the macro, it didn't record anything but the selection of the cells.
the following formula to be converted to vb for my userform.
=ROUNDUP(+J16-50000,-3)*0.00364+352
this is part of the vb that i'm working with and i need to change the part after "Then Amount =" I just can't seem to work out where to put the roundup bit.
I just wanted to know do we have a macro which can convert PDF to excel......?
View 4 Replies View RelatedI am trying to convert the following:
A2 = 02-OCT-06 A3 = 6275
Whereas A2 is the normal date and A3 is the converted Julian day. What is the simplest formula to enter into A3 to achieve this?