Excel time function help please

[Beagle-eye]

There are numerous formats for cell contents but, to my recollection, hh:mm is not a standard one. It is straightforward enough to define a custom cell format of hh:mm then simply input your data as that format and excel deals with the rest of it.