I've got a large spreadsheet that displays time in " 0130P" format and need to convert that to military time so that it reads "13:30". Is there and easy way or programming function to call this?

Thanks!!!

Thanks!!!

- Convert decimal hour into time format?
- Converting from 12-hour to 24-hour format
- Convert Hh:mm.* To 12 Hour Time Format
- VBA To Convert Decimal Number To Time Showing Hours & Minutes
- VBA to convert time string
- Excel should be able to format 12-hour times without am/pm
- How to convert total hours (HH:MM) into decimal number
- 12-hour time data treated as text
- Excel should be able to format 12-hour times without am/pm
- VBA to convert list and sort?
- How to set a formula to convert the time zone
- Electronic Timesheet: Subtracting 7pm on day 1 from 7am on day 2 to equa 12 hours???
- Convert Hours to Fractions of Hours
- VBA To Convert Text To Numbers
- VBA to convert fractions
- Macro or VBA to convert Excel sheet to JPEG, DICOM or TIFF formats
- Macro or VBA to convert Excel sheet to JPEG, DICOM or TIFF formats
- VBA to convert 1930-1999 year format to year 2000 format
- How to convert 6:80hrs imto 7:20hrs
- How can I convert fractional hours to minutes?
- Formula to convert PST into IST (Time)
- VBA to convert a portion of a formula from absolute to relative
- Best way to convert everything to values in a sheet
- How to convert 12/10/1970 to years/months/days

I use an start hour (2005-06-12 09.10.00) and the finish time (2005-06-17

17.39.14) from an offshore sailing race to get the hours sailed. Then I can

convert the hours (128.29.14) to decimal hour by using the =HOUR() etc to

extract the hour, minuts etc. With the decimal hour I can calculate the speed

in km/h or in this case knots.

But my question is how I can go the other way to convert decimal hour (1,5)

to time format (01.30.00)?

24-hour time entires? I have staff keeping track of "wait time" for an event

and I need the data in 24 hour format for equations. This doesn't always

happen.

Also, they will occasionally use ctrl-shift-; to enter the time, but I think

it enters in 12-hour format. Is there a shortcut for 24-hour format?

Thanks,

Nathan

http://www.ozgrid.com/forum/showthre...ours%2Fminutes

And understand the formula but have no clue on how to implement it. It shows a hardcoded value of 225 and I want it to use a cell reference. Any thoughts on this? TIA.

able to format times in a 12-hour format *without* having am/pm after each

time. In timetables, the am/pm is normally shown at the top of the column of

times, not against each time.

(I'm currently using Excel 2003)

----------------

This post is a suggestion for Microsoft, and Microsoft responds to the

suggestions with the most votes. To vote for this suggestion, click the "I

Agree" button in the message pane. If you do not see the button, follow this

link to open the suggestion in the Microsoft Web-based Newsreader and then

click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Where 30 minutes (xx:30) equals .50.

So far I have the formula

=(INT(VALUE(O16))*24)+(HOUR(VALUE(O16)))+((MINUTE( VALUE(O16))/100))

but still need to convert minutes to decimal

I have a problem using Excel to recognise 12-hour time data entries. If I enter 3:00 p in a cell, Excel will treat it as text.

In order to get Excel to recognise the correct format, I must use the 24-hour format, i.e I must enter 15:00 so that Excel knows it is 3:00 PM.

I have tried using both cell format General and Time. Still, it does not change the situation. I have also check the Regional and Language settings.

Does anyone encounter such issue with Excel?

Thanks and regards.

able to format times in a 12-hour format *without* having am/pm after each

time. In timetables, the am/pm is normally shown at the top of the column of

times, not against each time.

(I'm currently using Excel 2003)

----------------

This post is a suggestion for Microsoft, and Microsoft responds to the

suggestions with the most votes. To vote for this suggestion, click the "I

Agree" button in the message pane. If you do not see the button, follow this

link to open the suggestion in the Microsoft Web-based Newsreader and then

click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

thanks

Would like your help to advise on ow to set a formula on the following

Example : for 4/13/2006 11:22, how to set a formula to convert the US

mountain time to Asia/Singapore time?

US mountain time Convert to Asia/Singapore time

=========== ====================

4/13/2006 11:22 Please advise me the fourmula

4/13/2006 11:22

4/13/2006 11:22

4/13/2006 11:21

4/13/2006 11:20

4/13/2006 11:21

4/13/2006 11:20

4/13/2006 12:20

4/17/2006 3:10

4/18/2006 3:59

4/19/2006 2:32

4/18/2006 18:00

4/18/2006 2:59

4/18/2006 2:59

4/19/2006 2:34

4/19/2006 11:32

Your help is really much appreciated.

Thank you.

So, wouldn't it be nice if Excel could simply subtract 0700 on day 2 from 2300 the night before and have it = 8 hours. Unfortunately (as far as I can tell) it is not possible. So, I thought of changing the times (as seen in column W) to text, and just making them labels that equal the values located in column Y. This way I could have someone work 11pm to 11am (2300 - 1100) and be able to put in the 3rd shift row "2300 for "In" and 1100 for "Out" (all in the 3rd Row In/Out on the night where the shift started) and have it understand that 2300 = 23.00 and 1100 = 35.00; therefore 35 - 23 = 12 Hours for 3rd Shift???

I hope my description and screenshot are sufficient to get my question answered; please let me know if any futher clarification is needed. Thank you in advance for any assistance anyone can provide! The link below will take you to a screenshot of what I describe.

P.S. I thought about using If/then statements (for example IF D19 = W10, then Y10), but I am limited to like 30 or 60 of these, and I would need 144 of them to cover values for everything between 0000 on day 1 and 1100 on day 2 based on every quarter hour (total of 12 hours to include the .25, .50, and .75 for 15 past the hour, 30 past the hour and 45 past the hour...36 Hours x 4 = 144)

http://vanwyk.net/jon/spreadsheet01.jpg

I am attempting to convert a spreadsheet of times (listed in the format 06:15:39.62, where 06 is the hour, 15 is the minutes, 39 is the seconds, and .62 is in truncated miliseconds) into fractions of hours (so, 6.25 [NOT 6:25!]). I've so far been doing it manually for each value, which is quite tedious (doing basic division of seconds and minutes into hours, to find the fraction) but I'd like a single formula which I can then apply to the whole spreadsheet.

Unfortunately, I am at a total loss as to how to do this. Any help is appreciated.

I pull the data in the attached spreadsheet from a SharePoint query. The data is pulled over into Excel 2007 in the form of a table. I would like to convert the data in columns C through I from text to numeric so that I can use the AVERAGE forumula to calculate averages for each row. I would like to be able to do this through VBA as I will also automate adding and population of the averaged column. The only problem I see is that this data is dynamic. Each month I clear the spreadsheet and run the query to grab the latest data so I need to be able to select the data from a dynamic range and convert it to numbers. Any ideas on how I can accomplish this with VBA?

Thanks in advance!

Can someone help me, what i need is some vba code to convert a price with a fraction in it to a decimal figure.

Eg in cell A1 you have 1.03 1/2

B1 56.05 47/64

ect

i need to convert to 1.035

thanks

Mark

Communications System) in our medical imaging department. Our

PACS only accept JPEG or TIFF or DICOM format. Currently, we convert the

Excel sheet to PDF and then JPEG and then insert it in the PACS.

Is there a way (macro? VBA?) to program a cell (lets call it "Save as a

Picture") so that when I click on that cell, the worksheet get saved as jpeg

or tiff or dicom format?

Thank you for any comments or help in advance.

Dori

Communications System) in our medical imaging department. Our

PACS only accept JPEG or TIFF or DICOM format. Currently, we convert the

Excel sheet to PDF and then JPEG and then insert it in the PACS.

Is there a way (macro? VBA?) to program a cell (lets call it "Save as a

Picture") so that when I click on that cell, the worksheet get saved as jpeg

or tiff or dicom format?

Thank you for any comments or help in advance.

Dori

With wsAnalysis EndRow = .Range("E" & .Rows.Count).End(xlUp).Row For i = 2 To EndRow Cells(i, 5).Value = Next i End With

will u plz tell me how to convert a no into time

e.g. I want to calculate no of hours I worked in office for hat i entered in time & out time say 10.05 & 18.02 when i subtract out time from in time to calculate no of hours i worked it shows me 8.97 but idealy it should be 9hrs & 37 min so plz help me to get me the required result.

1.47 hours is 1 hour 28 minutes or 01:28:00.

Can anyone help me getting formula to convert Pacific Standard Time (PST) into Indian Standard Time (IST). The result should show time in AM/PM

Thanks in advance.

=IF(AND(Input!$C$3="",Input!$D$3=""),"",IF($F$3="cash","cash",IF(Input!$C$3>0,Input!$C$2,Input!$D$2)))

I now need to write code to change the formula to this

=IF(AND(Input!C3="",Input!D3=""),"",IF(F3="cash","cash",IF(Input!C3>0,Input!$C$2,Input!$D$2)))

Basically I need to convert characters C3, D3, F3 to RELATIVE while leaving characters $c$2, and $D$2 remain as ABSOLUTE. I know how to convert the entire formula to relative, but need help in coverting only a portion of the formula,

Suggestions are very welcomed

Marty

what is the best way in VBA to convert everything to values in a sheet whilst retaining the format of the cells?

thanks a lot

Andy