I have data that is in the format of 'd hr m s' and want to change it to [h]:mm. Where the h is the d*24+hr.
For example, this is the data that I currently have:
What can I do to format the cell, or what formula can I use to change the cell data to the format that I want?
Cheers