How to calculate time duration from date & times in individual times?

    I'm attempting to to calculate the time duration between two dates with equivalent time stamps.
    The two dates and equivalent times are in individual cells, therefor occupy 4 cells total. The formula below is the best I could do, however I can't seem to get the value in cell E4 to show in format hh:mm:ss.
    Might be as simple as formatting issue. Changing cell E4 format to time changes "105" to "00:00:00".

    Hi,


    Forget photos which are inert ...:sniff:


    Much better is to attach your file ... with an illustration of your expected result ... :smile:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Once you have tested the formula ... feel free to share your comments

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Glad you could fix your problem ... with quite a simple solution ...:wink:


    Thanks for your Thanks ...:smile:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login