Calculate total number of hours in a row

Thanks. LeroyG. I only really use Writer. This is the first time I’ve ever tried any kind of spreadsheet.

Hi @CaptainQuack . There were some incorrect manual calculations in your spreadsheet. You should just copy the formula from the cell above and paste it into the cells below to put the same formula (but with row number changed per cell) in each cell. It is very misleading to have mixed formulas and manual numbers. The spreadsheet is there to calculate, let it do its job. The corrections show you has overstated by 4 hours on your sheet.
See Wanderer’s comment about hours being fractions of a day too.
You might like to download the Calc Guide from documentation. Cheers, Al
cory-Al.ods (16.0 KB)

I checked on a site that does hours calculations. I have determined that I need to go back to elementary school to learn how to count. Old age sucks. Thanks again for all your help everyone.