Forum Discussion
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 s...
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,