Thread: Convert Time Decimal to standard time.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default 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
|


Reply With QuoteReply With Quote