| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hours and Minutes
You have to realise that if you store the hours as numeric, then 100.5
and 200.25 represent 100 hours 30 mins and 200 hours 15 mins respectively. However, if you really want to show this as hours and minutes, the following formula in C2 will do this: =TEXT(INT(B2),"0")&" hrs "&TEXT((B2-INT(B2))*60,"0")&" mins" Copy this down column C for as many values as you have in A and B. You can then hide column B if this causes confusion. Hope this helps. Pete |
| 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) | |||
| How to convert minutes to fractional hours | Excel Worksheet Functions | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| Help for a newbie trying to add hours and minutes :) | Excel Discussion (Misc queries) | |||
Threaded Mode
