I receive some requests from my clients. I need to register the date and time of receiving and upon delivering the order, I need to register the date and time for delivery and in the next column I need to calculate the duration for accomplishment (= Delivery date and time - receiving date and time) so that the result will be 3 (days) and (50) minutes for examples



Kindly help!

For periods less than a month, Excel can do this automatically without the need for macros, via a simple subtraction formula and a custom cell format (d h:mm:ss). For greater periods, a different formula can be used.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

attached a sample, it's not giving the result I need

Attached Files

try.xlsx (9.5 KB, 21 views)

The formula is working OK, but you haven't applied the custom format (d h:mm:ss) needed to turn it back into a normal day/time representation.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I've tried it. It's fine. Thanks.
what if the period exceeds one month?

As I said, you'd need a formula; with custom formatting, Excel can show months as well but, just like real months, they'll have variable day counts, depending on how many days there are in (IIRC) the current month. A formula might be:
=INT(A1-A2)&" "&TEXT(MOD((A1-A2),1),"hh:mm:ss")

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks again. issue resolved