| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Total days worked /20 to get actual months/days
We have to report actual days worked by months/day. A work month = 20 days.
How do I take total days worked of say 76 and get the answer to show 3 months 16 days? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Total days worked /20 to get actual months/days
=INT(A2/20)&" months "&MOD(A2,20)&" days"
-- __________________________________ HTH Bob "Cindy" wrote in message ... We have to report actual days worked by months/day. A work month = 20 days. How do I take total days worked of say 76 and get the answer to show 3 months 16 days? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Total days worked /20 to get actual months/days
Try this...
A1 = 76 For the months: =INT(A1/20) For the days: =MOD(A1,20) If you want it combined into a single expression (all on one line): =INT(A1/20)&" Month"&IF(INT(A1/20)<1,"s","") &" "&MOD(A1,20)&" Day"&IF(MOD(A1,20)<1,"s","") -- Biff Microsoft Excel MVP "Cindy" wrote in message ... We have to report actual days worked by months/day. A work month = 20 days. How do I take total days worked of say 76 and get the answer to show 3 months 16 days? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Total days worked /20 to get actual months/days
Days worked in A1
=INT(A1/20)&" months "&20*((A1/20)-INT(A1/20))&" days" Entered in B1 Gord Dibben MS Excel MVP On Thu, 22 Oct 2009 14:20:01 -0700, Cindy wrote: We have to report actual days worked by months/day. A work month = 20 days. How do I take total days worked of say 76 and get the answer to show 3 months 16 days? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CALCULATE THE ACTUAL AGE IN TERMS OF YEARS, MONTHS AND DAYS | Excel Worksheet Functions | |||
| Employee days worked (-Holidays, -weekends, Snow Days, etc) | Excel Discussion (Misc queries) | |||
| FORMULA, DAYS WORKED TO VACATION DAYS | Excel Worksheet Functions | |||
| how do i convert a number of days to years, months & days? | Excel Discussion (Misc queries) | |||
| i have two days and i want the difference in days, months, year | Excel Worksheet Functions | |||
Linear Mode
