Update Query (minutes into hours)
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 CP wrote: IS there a way to update a cell that currently has minutes (117) and to update that into hours (1:57)? |
All times are GMT +1. The time now is 03:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com