| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
converting hours to hours & minutes
Hi, can anyone help me convert calculated hours (2.9) to display as Hours &
Minutes (2:54). Cheers; Peter |
|
#2
|
|||
|
|||
|
converting hours to hours & minutes
With 2.9 in cell A1
=TIME(INT(A1),MOD(A1,1)*60,0) Change the cell format as needed. "Excel Hack" wrote: Hi, can anyone help me convert calculated hours (2.9) to display as Hours & Minutes (2:54). Cheers; Peter |
|
#3
|
|||
|
|||
|
converting hours to hours & minutes
Hi!
Try this: =(Yourformula(.......))/24 Format the cell as h:mm Biff "Excel Hack" <Excel wrote in message ... Hi, can anyone help me convert calculated hours (2.9) to display as Hours & Minutes (2:54). Cheers; Peter |
| 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) | |||
| Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions | |||
| Help for a newbie trying to add hours and minutes :) | Excel Discussion (Misc queries) | |||
| How do I add/subtract hours and minutes when some values exceed 2. | Excel Discussion (Misc queries) | |||
Linear Mode
