Free Microsoft Excel 2013 Quick Reference

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

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

## Related Results

### How do you plot more than 24 hours in a graph?

Hello,

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

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

Any help appreciated.

Thanks, Manda.

### How do I view more than one tab at a time, within a given workshee

How do I view more than one tab at a time, within a given worksheet, without
opening copies of that worksheet? Neither splitting the window nor freezing
panes appear to provide this function.

### How do I convert Quattro Pro 9.0 files to Excel?

How do I convert Quattro Pro 9.0 files to Excel?

### SUM (How do i add more than one amount in a single cell)

I have a Sunday through Saturday work sheet.
I would like to know how would i add more than one amount in a single cell?

### How do I see more than 1000 records filtered

When I am filtering a colum I can't see some records, when I read the help
issue it says that I can only see the first 1000 records filtered, how can i
see more than 1000 records.

### How do i get more than three conditional formats in excel

I have Excel 2002 which provides up to three conditional formats for each
cell. How can I get more than three?

### How do i convert angles from degrees,minutes, seconds to decimal

Can someone please tell me how to convert angles from degrees:minutes:seconds
to decimal degrees an vice versa using excel

### How do you average more than 30 time points in Excel

Trying to get the average of over one hunded times, in hours and minutes
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?

### How do you average more than 30 time points in Excel

Trying to get the average of over one hunded times, in hours and minutes
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?

### How do you convert 000:00:00:00 format to value?

000:00:00:00

Days, Hours, Mins, Secs

How do I convert it to value?

=Time*24 does not work.

Anyone?

### How do I calculate minutes when given two times?

I have a spreadsheet that contains one set of cells that is time in and
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>

### How do I get total amount of hours in time format

05:20
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

### How do I convert a time format to a double

I use a function to calculate the hours worked based on time

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?

### How do I calculate minutes when given two times?

I have a spreadsheet that contains one set of cells that is time in and
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>

### Format:How do I convert time (2:30) to a number (2.5) in a formula?

=A1*24 and format as general.

--

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?

### How do I transfer more than one column of a list box to the active cell?

This code works perfectly for insterting the selected item into the active cell, however it will only insert the selected item of column 1 of the list box, how do I enable it to transfer column 2/3 of the list box?

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 If

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

### How do I convert text to date?

Hi there - I have copied about 35,000 records from our website and pasted them into MS Excel 2010. They are formatted as text in the following way: 08/28/2010 17:52:49

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!

### How do I convert a excel 2007 worksheet to a memory stream?

How do I convert a excel 2007 worksheet to a memory stream?
or

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

### How do I make more than 12 entries in excel balance sheet templat.

The excel balance sheet template is exactly what I need. How do I get it to
expand to an infinite number of entries?? office xp

### How do I convert the result of LARGE to the cell (or column) refe.

How do I convert the result of LARGE to the cell (or column) reference from
which the value is derived? I wish to use the cell reference to control an IF
statement.

### How do I convert time (2:30) to a number (2.5) in a formula?

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?

### How do I convert numeric value to its character value ex. 10=Ten

Please suggest me how do I convert a numeric value to its character value.
for example
1 = one
2 = two
3 = three
4 = four
5 = five

### How do i get a cell in a sheet to show the last 1024 characters?

How do I get a cell in a sheet to display the last 1024 characters instead of
the first 1024 characters when the cell contains more than 1024 characters?

### How do I convert a time eg. 00:01:39 to a duration eg. 1.65 min o.

How do I convert a time eg. 00:01:39 to a duration eg. 1.65 min or 99 seconds
in order to multiply the duration with an amount or rate to give me a cost?