Forum Discussion

ar3inc's avatar
ar3inc
Copper Contributor
Feb 22, 2021

Adding hours

This is an issue I had for a while but being just a personal project I haven't really pushed on working it.  However, based on the knowledge here, opposed to the general internet, I want to try this issue here.

I have a log with a starting and end timestamp, then a cell that figures the hours of elapsed time.  The time for each event usually falls around 23-26 hours.

 

TEXT(B16-A16,"[hh]:mm")

 

At the bottom of the log, I tried to compile totals for each data point.  The elapsed time column fails to total.  It gives zero.  I have tried just basic SUM, bringing it in a TEXT format.

 What am I doing wrong?

 

Thanks!

2 Replies

  • ar3inc 

    The TEXT function, as its name implies, returns a text value. The SUM function ignores text values.

    Change the formula to

    =B16-A16

    and set the number format to the custom format [hh]:mm

    The SUM formula should then work as intended. Format the cell with this formula as [hh]:mm too.

    • ar3inc's avatar
      ar3inc
      Copper Contributor
      Well, that is a super stupid simple solution! Thanks again!

Resources