| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Time Decimal to standard time.
Does anyone know a formula that would help me convert a time decimal
value to a standard time format? i.e. conver 4.63 to 4:38 Any assistance is greatly appreciated. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Convert Time Decimal to standard time.
=A1/24, Format as Time
-- Kind regards, Niek Otten Microsoft MVP - Excel "GTVT06" wrote in message ups.com... | Does anyone know a formula that would help me convert a time decimal | value to a standard time format? i.e. conver 4.63 to 4:38 | | Any assistance is greatly appreciated. | | Thanks | |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Convert Time Decimal to standard time.
A1 = 4.63
A2 = A1/24 << Format as Time 00:00 "GTVT06" wrote: Does anyone know a formula that would help me convert a time decimal value to a standard time format? i.e. conver 4.63 to 4:38 Any assistance is greatly appreciated. Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Convert Time Decimal to standard time.
It worked!!!! Thanks!!!! I didn't know the formula was going to be that
simple! Niek Otten wrote: =A1/24, Format as Time -- Kind regards, Niek Otten Microsoft MVP - Excel "GTVT06" wrote in message ups.com... | Does anyone know a formula that would help me convert a time decimal | value to a standard time format? i.e. conver 4.63 to 4:38 | | Any assistance is greatly appreciated. | | Thanks | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert standard time to 30 min increments? | Excel Discussion (Misc queries) | |||
| convert standard number to time format | Excel Worksheet Functions | |||
| How to I convert standard time to Military or 24 hour format? | Excel Discussion (Misc queries) | |||
| how do i convert standard time format into seconds? | Excel Discussion (Misc queries) | |||
| Converting decimal time to standard time? | Excel Discussion (Misc queries) | |||
Linear Mode
