| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert decimal values to hours & minutes in Excel 2000?
For example if I have, say, the value 4.88 in a cell I want to convert it to
4h 53' |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert decimal values to hours & minutes in Excel 2000?
Divide by 24
=A1/24 format as time and you'll get 04:52:48 if you really want 04:53 you would need to round, but then you need to decide what rounding to use, nearest quarter hour, nearest half hour etc -- Regards, Peo Sjoblom "Bo0ts" wrote in message ... For example if I have, say, the value 4.88 in a cell I want to convert it to 4h 53' |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert decimal values to hours & minutes in Excel 2000?
=A1/24
Format cells as: h:mm "Bo0ts" wrote: For example if I have, say, the value 4.88 in a cell I want to convert it to 4h 53' |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert decimal values to hours & minutes in Excel 20
Cool! Works well... Now, how do I roundup to nearest quarter hour?
Regards, Bo0ts "Peo Sjoblom" wrote: Divide by 24 =A1/24 format as time and you'll get 04:52:48 if you really want 04:53 you would need to round, but then you need to decide what rounding to use, nearest quarter hour, nearest half hour etc -- Regards, Peo Sjoblom "Bo0ts" wrote in message ... For example if I have, say, the value 4.88 in a cell I want to convert it to 4h 53' |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert decimal values to hours & minutes in Excel 20
=CEILING(A1/24,1/96)
"Bo0ts" wrote: Cool! Works well... Now, how do I roundup to nearest quarter hour? Regards, Bo0ts "Peo Sjoblom" wrote: Divide by 24 =A1/24 format as time and you'll get 04:52:48 if you really want 04:53 you would need to round, but then you need to decide what rounding to use, nearest quarter hour, nearest half hour etc -- Regards, Peo Sjoblom "Bo0ts" wrote in message ... For example if I have, say, the value 4.88 in a cell I want to convert it to 4h 53' |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert decimal values to hours & minutes in Excel 20
One way
=ROUND(A1/24/(1/96),)*(1/96) will round to the nearest quarter hour in time format, a couple of other ways =ROUND(A1/24/TIME(,15,),)*TIME(,15,) =ROUND(A1*4,)/4/24 the latter does the rounding first on the decimals and then converts it to time -- Regards, Peo Sjoblom "Bo0ts" wrote in message ... Cool! Works well... Now, how do I roundup to nearest quarter hour? Regards, Bo0ts "Peo Sjoblom" wrote: Divide by 24 =A1/24 format as time and you'll get 04:52:48 if you really want 04:53 you would need to round, but then you need to decide what rounding to use, nearest quarter hour, nearest half hour etc -- Regards, Peo Sjoblom "Bo0ts" wrote in message ... For example if I have, say, the value 4.88 in a cell I want to convert it to 4h 53' |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert decimal values to hours & minutes in Excel 20
You said roundup didn't you. The formulas I provided round to the nearest
quarter =ROUNDUP(A1/24/(1/96),)*(1/96) or =CEILING(A1/24,1/96) -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... One way =ROUND(A1/24/(1/96),)*(1/96) will round to the nearest quarter hour in time format, a couple of other ways =ROUND(A1/24/TIME(,15,),)*TIME(,15,) =ROUND(A1*4,)/4/24 the latter does the rounding first on the decimals and then converts it to time -- Regards, Peo Sjoblom "Bo0ts" wrote in message ... Cool! Works well... Now, how do I roundup to nearest quarter hour? Regards, Bo0ts "Peo Sjoblom" wrote: Divide by 24 =A1/24 format as time and you'll get 04:52:48 if you really want 04:53 you would need to round, but then you need to decide what rounding to use, nearest quarter hour, nearest half hour etc -- Regards, Peo Sjoblom "Bo0ts" wrote in message ... For example if I have, say, the value 4.88 in a cell I want to convert it to 4h 53' |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert hours, minutes, and seconds into decimal format? | Excel Worksheet Functions | |||
| Convert Decimal hours and Minutes to minutes please. | Excel Worksheet Functions | |||
| Convert days in decimal to days:hours:minutes | Excel Worksheet Functions | |||
| Convert decimal days to Days,hours, minutes | Excel Worksheet Functions | |||
| How to convert decimal values (dd.dddddd) to degrees/minutes/seco. | Excel Worksheet Functions | |||
Linear Mode
