conversion

I have been attempting to convert numbers such as '080952' to 08:09:52 am. I have tried time conversion by formatting cells, and when I do I receive 0 or 12:00am. I have used the following formula: =TIME(VALUE(LEFT(B2,2)),VALUE(MID(B2,3,2)),VALUE(RIGHT(B2,2))) and it works well for the most...

Hi there, I am looking for help changing the format of time that is wrongfully set as 15:00:00 but should read 00:15:00. This seems like such a simple issue but I am struggling to fix due to the complications dealing with Time formats. Help is greatly appreciated. Steve

Hello! I have entered most of my thesis data into excel- and I am looking for a way to avoid re-typing all my columns... I am using Microsoft Excel 2010 I entered times into a column (intended to represent time elapsed, mm:ss) but excel auto-formatted it to time of day (hh:mm:dd). It shows in...

Hello! I am new here, but excited I found this forum. Your help is greatly needed! I just started at a new company and they had not been converting the numbers from 1/60 to 1/100 for the paychecks for over 6 months. There are a lot of employees and doing everyone by hand would take days. Could...

I have a column with the value " 50000000000000 " in each cell But it shows the following : <tbody> 5.00E+13 5.00E+13 5.00E+13 5.00E+13 5.00E+13 5.00E+13 </tbody> How can i convert it to " 50000000000000" This has happened when stored in .csv file. Thanks in advance

Found very useful code to convert Hiiri to Gregorian dates on http://www.islamicsoftware.org/ I found another function which calculates date of Eid Al Adha as a Hijri date. The two functions aside work fine, however if I try to use the code to convert the Hijri date of Eid Al Adha to a...

I have a column of dates on Column F(Gregorian) and it displays the Hijri dates on Column G. What is did is i formatted the all the cells Column G into Home -> Number -> DropDown More Number Formats -> Number -> Category -> Date -> Locale(Location) -> Arabic (Saudi Arabia) Then i just entered...

I have an excel document that is has about 15 sheets, I would like to create a pdf for each sheet. The problem i have is that when I go to do this, I lose the bookmarks I have set up. Is there any way to stop this from happening?

Hi, I need to do conversions on some data using ratios. (It's based on the reorganisation of spatial boundaries). I cannot figure out how to apply the different ratios to the same case/code (it's a very large database, so doing it individually is not possible) An example of my dataset...

I have data that I would like to see in seconds or minutes but the data I receive can come out many ways. For Example in Column D Row 2 it could read (5 hr 3 min) but row 3 could read (6 day 17 hr) and row 4 could read (21 min 58 sec). I would prefer to see this data in second so if it read (5...

Hello all; Learned a lot from lurking on this forum, first time needing some help. I have a countifs function I've been using for awhile that I use to count blanks between two columns. The value in these cells changes (they can be number or letters), so it doesn't look for anything specific...

Hi My sample text (which is general format when report generates) is this: 20141205 (December 5, 2014) How can I convert that to a date so that I may drag a formula down to count # of days? I tried dateif and datevalue and didn't work.

Hi, I have specific columns where I input values manually - the rows are constant so always from B11 to Q38 and down to row 72 (B-Q). The inputs are values in tonnes that I would like to convert to kilograms by adding three 0. However, some of the cells are also text cells which should not have...

Hi Folks, I have a badly structured CSV file that I have to scan as input to spreadsheet. Is there a way in VBA to scan for a string of spaces using a string function like Instr. Also in VBA I am looking for a function to convert numbers that are formatted using the european system with a comma...

I have a range of cells that is populated with weight amounts and an adjacent column with its pricing for shipping, for example: <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> 0.1 $0.75 0.3 $1 0.4 $1.15 0.6 $1.5 0.12 $2 0.14...

Thank you for your help, I need to create a calculator from a paper reference chart. Page 51 - Myron Toback 2009 Catalog above is a link to the page in my catalog. What I have currently is a spreadsheet with 3 sheets. Sheet 1 is text that has a dropdown for thickness and next to it is a...

From MS Word, using Mail Merge, it doesnt present entire set of rows to select. MS Word Mail Merge Edit recipient list When it pulls up the list from the Excel file, the rows it presents stop after a certain row. I don't see a visible problem with that row. If I delete the following row in...

I have a simple conversion script below that converts pressure from psi to kpa and flow from gpm to lpm. It is triggered from a shape I linked to the macro Toggle_Clickwtext(). This code is very long winded, but gets the job done. In an effort to sharpen my skills and create better and more...

I've got a data dump that must be edited/converted prior to pushing it into a different main frame system. There can be NO decimals in the end result. Here's the challenge: ______Col A____Col B___Col C___Col D____Col E Row1__TOT_____1Q_______2Q_____3Q______4Q_____...

I have a spreadsheet of credit card expiration dates, such as 1-17 or 12-16. Im using Right Click, Format Cells, Custom, then setting m-yy. In the past this worked correct when I would insert new dates, but now it converts or posts them incorrectly. For example, if I type 1-17, it will...