| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
=A1*24 and format as general.
-- HTH RP (remove nothere from the email address if mailing direct) "tammyj" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert interval to various separate date , time, hr, minutes | Excel Worksheet Functions | |||
| avoid retype the number more than one time withen acolumn | Excel Discussion (Misc queries) | |||
| how do i convert a number into minutes for a time of completion c. | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| how to convert total hours (HH:MM) into decimal number | Excel Worksheet Functions | |||
Linear Mode
