Title: calculate time difference
Last modified: February 12, 2018

---

# calculate time difference

 *  Resolved [planeo8](https://wordpress.org/support/users/planeo8/)
 * (@planeo8)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/calculate-time-difference/)
 * is it possible to calculate the time difference between 2 cells? for example,
   if cell a2 is the start time and cell b2 is the finish time, what would the formula
   be to calculate the time difference.
 * a2 time is 14:00:00
    b2 time is 15:30:00
 * i would like for c2 to display the time in the same format of hours:minutes:seconds.
   in excel, i would enter =b2-a2 in cell c2. i tried this but i got an error message…”!
   error! b2 does not contain a number or expression”
 * thanks for your help.

Viewing 1 replies (of 1 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/calculate-time-difference/#post-9962760)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * No, sorry, unfortunately, I’ll have to disappoint you here. TablePress does currently
   not support formulas for date and time calculations, but only those for plain
   numbers. (For a list, please see [https://tablepress.org/tablepress-features-formulas/](https://tablepress.org/tablepress-features-formulas/).)
 * Regards,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘calculate time difference’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [8 years, 5 months ago](https://wordpress.org/support/topic/calculate-time-difference/#post-9962760)
 * Status: resolved