| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
easiest way to convert a number to hours
i am adding up some time durations and storing it in a variable. when the variable is greater than 1, 1.384 for example, i need to format it in hours and minutes and put the value in a cell. i keep only getting the hours greater than 24, 9:13:04, in this case. format(variablename,"hh:mm:ss") is what i tried. is there a way to format the number rather than doing the math to get 33:13? -- Gary |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert a number to Hours, Minutes, etc. | Excel Discussion (Misc queries) | |||
| Convert Number in to Hours.... | Excel Worksheet Functions | |||
| 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 | |||
Threaded Mode
