Forum Discussion

JAV6's avatar
JAV6
Tin Contributor
Jul 15, 2026
Solved

Compute elapsed time

I have a spreadsheet of charging time for my Jeep. I would like to calculate the duration of the charging period but am having problems coming up with a formula that would work.  It would have to...
excel
Formulas and Functions
  • m_tarler's avatar
    m_tarler
    Jul 17, 2026

    Ah you have Excel 2013.  That doesn't have access to these newer functions.

    By Date-Time combined format I just mean put the whole date AND time into a single cell:

    Start                              End                                             Total

    6/26/2026 16:03            6/27/2026 04:06                          =B5-A5 

     

    the alternative using your current format might be something like:

    G5 = HOUR ( D5+TIME(E5,F5,0) - A5 - TIME(B5,C5,0) )

    H5 = MINUTE ( D5+TIME(E5,F5,0) - A5 - TIME(B5,C5,0) )

JAV6's avatar
JAV6
Tin Contributor
Jul 17, 2026

Doesn't work for me in my version of Excel.

How are you 'combining' the individual cells?

m_tarler's avatar
m_tarler
Silver Contributor
Jul 17, 2026

Ah you have Excel 2013.  That doesn't have access to these newer functions.

By Date-Time combined format I just mean put the whole date AND time into a single cell:

Start                              End                                             Total

6/26/2026 16:03            6/27/2026 04:06                          =B5-A5 

 

the alternative using your current format might be something like:

G5 = HOUR ( D5+TIME(E5,F5,0) - A5 - TIME(B5,C5,0) )

H5 = MINUTE ( D5+TIME(E5,F5,0) - A5 - TIME(B5,C5,0) )