B4 formula:

=INT(A4-A3)

C4 formula:

= text (if (A4<& gt0, a4-a3, "","mm min ss sec when").

Result formula:

= B4&"God"&; C4？

Summary: If you only get the date, you will lose the information if you don't get the date information. This should be a problem with the software version.

Hope to adopt, thank you.

—————————— The following is my previous reply (negligible) ———————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————.

I changed your formula:

= text (if (A4<& gt0, A4-A3, "","yy mm month dd day hh mm minute ss second).