If the hours will be less than 24 then use 127/60 and format the cell as time
using 24 hour clock.

If the hours will be 24 or greater use =int(127/60)&":"&text(mod(127,60),"00")
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Colette" wrote:

I have a project which only gives me minutes. I need to convert the total
minutes to hours and minutes. Example: 127 is the number (total minutes).
I need it to read it took 2 hours and 7 minutes to complete. Needs to look
like this 2:07