Thread: Convert part of decimal to time (minutes only)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RachelB RachelB is offline
external usenet poster
  
Posts: 5
Default Convert part of decimal to time (minutes only)
For example I have 39:83. I want to convert to 39:49

I want to only convert the :83 decimal into minutes.

I am using the =text(value/24, "h:mm") but this is converting 39:83 to 13.49.

Please can anyone help ?
Thanks



Reply With QuoteReply With Quote