time calculation

**amarjeet.it** · 09-01-2017, 01:21 PM

Hi everyone,
I have date like;
A B
1 Total calls per call
2 12000 0:06:00

I have to find out how much days, hours, minutes and seconds will take to complete the 12000 calls if one call ends for 0:06:00 (Aprox Six Minute).
Please help me.

Thanx in advance!!!

**Pauleyb** · 09-01-2017, 02:18 PM

=INT(A1*B1)& " Days " & TEXT(A1*B1,"hh:mm:ss")

**amarjeet.it** · 09-01-2017, 02:53 PM

very nice Pauleyb, It works like what i want. i Like it. But tell me how to display month also. for example 50 days 00:35:06( It must display like 1 month twenty days 00:35:06).

By the way, i am making it solve but plz i am requesting you to let me know above problem solution,
thanx again!!!

**Pauleyb** · 09-01-2017, 03:22 PM

This should get you started:
=TEXT(A1*B1,"mm dd hh:mm:ss")
Adjust the string as you see fit (like I did above to include the word 'Days'). Note, however, this is assuming a start on January 1900. So, the first month is 31 days, the next is 29, etc.