Add decimal min to time in one cell

[polska2180]

Hi I have the following...

ARRIVAL TIME	SERVICE TIME ACTL (MINS)
5:17 AM​	41​

In say column C I want to add the time to the min and have it show as HH:MM or H:MM but all the conversion would have to happen in the formula in cell C1...thanks.

 

[6StringJazzer]

To convert decimal minutes to Excel time, divide by the number of minutes in a day.

=A1+B1/(24*60)

 

[Fluff]

How about

=A2+TIME(0,B2,0)

 

[6StringJazzer]

There's more than one way to skin a cat!