| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Number in to Hours....
Hi,
I have to fill the time sheet, in that i have to give activity name and hours i worked on the activity.when I sum the total of hours i worked ,it is taking as normail No..Can i get any formula to covert it in to hours and minuts Ex : A1 activity i worked for 30mins (.30) , A2 activity I work... 1h.20 min (1.20) , A3 - 1h .50m (1.50) if I sum the total it had to show 3h.40min (but it is showing as 3 ) Can I get any formula for this ...? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert dd:hr:mn:ss to Decimal number of hours | Excel Discussion (Misc queries) | |||
| Convert Total Hours and Minutes to Whole Number | Excel Worksheet Functions | |||
| Is it possible to convert a number into hours and minutes | Excel Worksheet Functions | |||
| Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
| how to convert total hours (HH:MM) into decimal number | Excel Worksheet Functions | |||
Threaded Mode
