Excel formula to calculate the Days, Hours, Min and sec between two cells which are having data in date format

By | April 22, 2024
0 Comment

=INT(B2-A2)&” Days “&HOUR(MOD(B2-A2,1))&” Hour “&MINUTE(MOD(B2-A2,1))&” Minutes”

Leave a Reply

Your email address will not be published. Required fields are marked *