Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have been going around in circles trying to write a formula to get weeks,
days, hours, and minutes. (e38/h37)/2 is the amount of hours. The format I would like the output to have is: X week(s), X day(s), X hour(s), X minute(s) If one doesn't apply, I would like it to NOT be displayed. This should be easy, but with all of the rounddowns, mods, etc. plus having all the text added into all of the if statements to get the plurals right, I am just frozen. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple calculations within cell? Writing in Excel 2000, using inExcel 2003 | Excel Worksheet Functions | |||
Scrolling in Excel 07 while writing a formula - Please help!!! | Excel Discussion (Misc queries) | |||
need help writing a formula in excel | New Users to Excel | |||
Writing formula for excel worksheet | New Users to Excel | |||
Help writing an Excel Formula | Excel Worksheet Functions |