Total days worked /20 to get actual months/days

C

Cindy

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?
 
T

T. Valko

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","")
 
G

Gord Dibben

Days worked in A1

=INT(A1/20)&" months "&20*((A1/20)-INT(A1/20))&" days"

Entered in B1


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top