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
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
=A1/24, Format as Time
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"GTVT06" <[email protected]> wrote in message news:[email protected]...
| 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
|
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
>
>
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" <[email protected]> wrote in message news:[email protected]...
> | 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
> |
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks