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) )

m_tarler's avatar
m_tarler
Silver Contributor
Jul 15, 2026

If you enter the data as Date-Time combined format then a simple difference will work.

Here I basically combine the individual cells and then use HSTACK to then break Hour and Min up:

=LET(t,D5+TIME(E5,F5,0)-A5-TIME(B5,C5,0),HSTACK(HOUR(t),MINUTE(t)))

but each of those could be arrays too so all the results could be:

=LET(t,D5:D6+TIME(E5:E6,F5:F6,0)-A5:A6-TIME(B5:B6,C5:C6,0),HSTACK(HOUR(t),MINUTE(t)))

or more generally:

=LET(t,D5:.D99+TIME(E5:.E99,F5:.F99,0)-A5:.A99-TIME(B5:.B99,C5:.C99,0),HSTACK(HOUR(t),MINUTE(t)))