Format for Estimated Time of Arrival

[excelwhat]

I am trying to create a sheet that shows how long a specific drive will take, by dividing the mileage in one column by 55 mph (which is not in a column) and get and answer that shows the length of time it takes in Hours : Minutes.

I already have the formula, but I cannot find the correct Formatting to produce the Hour : Minutes. Is there one?

 

[excelwhat]

@SHG -

The only one I see is [h]:mm:ss

Which is great, it is definitely an ETA that I'm looking for but I really don't need the :ss (seconds) to be included.

Can you create a format?

Thanks so much for your response, it was very helpful!

 

[excelwhat]

@SHG

I got it! Figured it out!!

Thanks so much!!

 

[shg]

Welllll, good job!