Update Query (minutes into hours)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

IS there a way to update a cell that currently has minutes (117) and to
update that into hours (1:57)?
 
Hi

With your 117 mins in A1
=INT(A1/60)&":"&MOD(A1,60)

Regards

Roger Govier
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text to Numbers 3
Hour function equivelent help 3
Convert minutes into hours 3
Converting time to Minutes 2
Vacation Tracking formula 1
Excel Formula for adding training times. 1
=hour formula 3
Time Calculation 9

Back
Top