View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mailrail mailrail is offline
external usenet poster
 
Posts: 28
Default Wacky time calculation

One of my data sheets at work brings numbers into Excel as decimals. For
instance, 5 hours and 39 minutes is shown as 5.39. How can I get Excel to
convert this to 5:39 (semicolin instead of decimal)?