Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display words in a formula result in Excel
I used the [hh]:mm number format to add hours and minutes. Is there a way to
display the result of 46:40 as 46 hours and 40 minutes |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display words in a formula result in Excel
Yes
[h] "hours and" mm "minutes" -- Regards, Peo Sjoblom (No private emails please) "dhollifield" wrote in message ... I used the [hh]:mm number format to add hours and minutes. Is there a way to display the result of 46:40 as 46 hours and 40 minutes |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display words in a formula result in Excel
Try the custom format
[hh] "hours and" mm "minutes" Hope this helps Rowan dhollifield wrote: I used the [hh]:mm number format to add hours and minutes. Is there a way to display the result of 46:40 as 46 hours and 40 minutes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can an IF formula result in a color filled cell in Excel? | Excel Worksheet Functions | |||
Bring back the FORMULA RESULT BAR in excel | New Users to Excel | |||
Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions |