How do I convert more than 24 hours time to decimal?

--

Many thanks for your help in advance. Have a wonderful day!

Zsolt

--

Many thanks for your help in advance. Have a wonderful day!

Zsolt

- How do you plot more than 24 hours in a graph?
- How do I view more than one tab at a time, within a given workshee
- How do I convert Quattro Pro 9.0 files to Excel?
- SUM (How do i add more than one amount in a single cell)
- How do I see more than 1000 records filtered
- How do i get more than three conditional formats in excel
- How do i convert angles from degrees,minutes, seconds to decimal
- How do you average more than 30 time points in Excel
- How do you average more than 30 time points in Excel
- How do you convert 000:00:00:00 format to value?
- How do I calculate minutes when given two times?
- How do I get total amount of hours in time format
- How do I convert a time format to a double
- How do I calculate minutes when given two times?
- Format:How do I convert time (2:30) to a number (2.5) in a formula?
- How do I transfer more than one column of a list box to the active cell?
- How do I convert text to date?
- How do I convert a excel 2007 worksheet to a memory stream?
- How do I make more than 12 entries in excel balance sheet templat.
- How do I convert the result of LARGE to the cell (or column) refe.
- How do I convert time (2:30) to a number (2.5) in a formula?
- How do I convert numeric value to its character value ex. 10=Ten
- How do i get a cell in a sheet to show the last 1024 characters?
- How do I convert a time eg. 00:01:39 to a duration eg. 1.65 min o.

I need to create a stock graph which needs more than 24 hours on the y axis.

How do you show more than 24 hours?

One graph needs 27 hours while the other needs 31 hours.

Any help appreciated.

Thanks, Manda.

opening copies of that worksheet? Neither splitting the window nor freezing

panes appear to provide this function.

I would like to know how would i add more than one amount in a single cell?

issue it says that I can only see the first 1000 records filtered, how can i

see more than 1000 records.

cell. How can I get more than three?

to decimal degrees an vice versa using excel

format. Excel says that the Average function will not work for over thirty

data points. It works for other spreadsheets, where I have fewer time points.

How do you average more than 30 data points?

format. Excel says that the Average function will not work for over thirty

data points. It works for other spreadsheets, where I have fewer time points.

How do you average more than 30 data points?

000:00:00:00

Days, Hours, Mins, Secs

How do I convert it to value?

=Time*24 does not work.

Anyone?

Days, Hours, Mins, Secs

How do I convert it to value?

=Time*24 does not work.

Anyone?

another set of cells that is time out.

I have been able to calculate elapsed time in hours and minutes by

converting the time in and time out to military time. Excel is reading this

as a time of day rather than the length of time.

How do I convert the elapsed time into minutes so that I can measure averages>

07:20

07:30

07:30

07:00

05:20

05:45

the above numbers are all individual times eg ( 5 hours and 20 minutes). I

need to add them all, which should come up to 45 hours and 5 minutes. The

format is [h]:mm for more than 24 hours, but the toatl it shows is 93:45

.. Can anyone show me which formula to use to add up time. I have tried all

other from different websites(mrexcel.com etc) and have tried all of ther

suggestions, but still am stumped

12:00pm to 4:00pm is 4.0 hours

when I get the number for hours worked it is in time format / .27398237 I

need the number 4 so that I can do my calculation. How do I convert it to a

number?

another set of cells that is time out.

I have been able to calculate elapsed time in hours and minutes by

converting the time in and time out to military time. Excel is reading this

as a time of day rather than the length of time.

How do I convert the elapsed time into minutes so that I can measure averages>

--

HTH

RP

(remove nothere from the email address if mailing direct)

"tammyj" <tammyj@discussions.microsoft.com> wrote in message

news:6AEDACE1-7634-4683-913A-49397596ACA2@microsoft.com...

> The difference in time between 12:00 am and 2:30 am is 2:30. How do I

> convert that to a decimal (2.5) in the same formula?

VB:Image1_Click() Dim lItem As Long With ActiveCell.Characters 'Change Shape & Sheet name to suit .Text = vbNullString For lItem = ListBox2.ListCount - 1 To 0 Step -1 If ListBox2.Selected(lItem) = True Then .Text = ListBox2.List(lItem) & "," & .Text ListBox2.Selected(lItem) = False Next .Text = Left(.Text, Len(.Text) - 1) End With End Sub End IfIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

How do I convert them from text to date, and also convert them from US to UK format so that I can analyse and order them?

I have tried the "text to columns" function using the DMY format and I have also tried to convert them manually by formatting the cells as date 04/12/10 etc using the format cells function.

Any help would be most gratefully appreciated!

or

How do I convert a excel 2007 worksheet to an array of bytes?

Thanks in advance.

expand to an infinite number of entries?? office xp

which the value is derived? I wish to use the cell reference to control an IF

statement.

convert that to a decimal (2.5) in the same formula?

for example

1 = one

2 = two

3 = three

4 = four

5 = five

the first 1024 characters when the cell contains more than 1024 characters?

in order to multiply the duration with an amount or rate to give me a cost?