Forum Discussion

Ruth Caputo's avatar
Ruth Caputo
Copper Contributor
Oct 06, 2017

Convert date and time to elapsed time

I'm running a study over several months. I want to plot the data as a function of elapsed time. How do I convert date (one field) and time (one field) to elapsed time in days after the start of the study (one field)?

excel

1 Reply

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Oct 06, 2017

    Hi,

     

    You may find the answer you want in one of these links:

     

    https://exceljet.net/formula/calculate-elapsed-work-time

    https://support.office.com/en-us/article/Add-or-subtract-time-16aa6697-6d6e-49c1-8e2c-3398a7cad6ad

    https://www.ablebits.com/office-addins-blog/2015/06/24/calculate-time-excel/

     

    Regards,

Resources