Hidden code?

Arazon
Member

177

02-26-2023, 10:00 PM

I have a column of times in Google sheets which are summed at the bottom. The formula at the end is =Sum(F5:F41). The result is clearly incorrect. When I reduce the range to F5:F16, it works properly. Once I move to F17, the total changes to an inaccurate value. All rows, columns, and cells appear correct, so the issue must be hidden code within a cell. Any ideas would be appreciated.

Arazon

02-26-2023, 10:00 PM #1

TheBlackCatHD
Member

171

02-26-2023, 10:36 PM

what is on f17?
test it by typing the value in f17 by hand?

TheBlackCatHD

02-26-2023, 10:36 PM #2

what is on f17?
test it by typing the value in f17 by hand?

ViacoolHD
Member

02-28-2023, 04:37 PM

There is an incorrect number at the bottom of the column.

ViacoolHD

02-28-2023, 04:37 PM #3

There is an incorrect number at the bottom of the column.

Si0neR
Member

235

03-01-2023, 12:04 PM

The cell column has been formatted.

Si0neR

03-01-2023, 12:04 PM #4

The cell column has been formatted.

PowergirlA
Member

229

03-01-2023, 05:35 PM

Wrong by hours. Displays 8:30 total instead of the correct 62:15.
I found a workaround:
Since I need total time, not just hours and minutes, I added another column and stored time as decimal values.
=HOUR(F5)+MINUTE(F5)/60
Got the data I required.
Thanks.

PowergirlA

03-01-2023, 05:35 PM #5

tyrjersia
Junior Member

03-01-2023, 07:12 PM

It's challenging to assess a spreadsheet that isn't visible.

tyrjersia

03-01-2023, 07:12 PM #6

It's challenging to assess a spreadsheet that isn't visible.

AcyLeaK
Junior Member

03-01-2023, 08:14 PM

Acknowledged.
The issue is resolved.
Thank you.

AcyLeaK

03-01-2023, 08:14 PM #7

Acknowledged.
The issue is resolved.
Thank you.