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?

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?

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?

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?