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


Reply With QuoteReply With Quote