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