Thread: Need help with time
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Keith74 Keith74 is offline
external usenet poster
  
Posts: 120
Default Need help with time
This is fairly handy as an alternative

=TEXT(5.87/24,"h:mm")

hth

Keith


Reply With QuoteReply With Quote