| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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)? |
|
#2
|
|||
|
|||
|
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)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding hours and minutes | Excel Worksheet Functions | |||
| Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins? | Excel Discussion (Misc queries) | |||
| Help for a newbie trying to add hours and minutes :) | Excel Discussion (Misc queries) | |||
| Adding hours and minutes | Excel Discussion (Misc queries) | |||
| convert hours and minutes to minutes | Excel Discussion (Misc queries) | |||
Linear Mode
