Thread: Converting Days:Hours:Minutes:Seconds into Hours:Minutes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Converting Days:Hours:Minutes:Seconds into Hours:Minutes
Hi,

Am Wed, 1 Nov 2017 12:07:07 -0700 (PDT) schrieb :

Please can i get some help with how to convert a cells format from Days:Hours:Minutes:Seconds (eg 4:03:14:46) into hours:minutes.
Many thanks.
P.S Have tried changing format of cell to H:MM but no good.

your value is a string because it has no valid number format.
If your value is in A1 then try:
=LEFT(A1,FIND(":",A1)-1)+MID(A1,FIND(":",A1)+1,5)
and format the cell with custom format [h]:mm


Regards
Claus B.
--
Windows10
Office 2016
Reply With QuoteReply With Quote