Converting Days:Hours:Minutes:Seconds into Hours:Minutes
 

Hi everyone
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.

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