B
bglodde
I've searched everywhere for a solution to these time problems.
1) In a column are a series of times (>100) that are in the hundreds of
hours (time formatted [hh]:mm:ss), I -cannot- SUM this column, so I had
to write a custom function for it. Other columns with lesser time
values SUM() properly.
Sample of the data:
244:11:30
224:58:13
112:24:10
...etc...
Why does SUM not work with large time values?
2) I also need to divide that large time value by a whole number, eg
=21519:51:56/1885
I cannot figure out how to make this happen!
TIA.
1) In a column are a series of times (>100) that are in the hundreds of
hours (time formatted [hh]:mm:ss), I -cannot- SUM this column, so I had
to write a custom function for it. Other columns with lesser time
values SUM() properly.
Sample of the data:
244:11:30
224:58:13
112:24:10
...etc...
Why does SUM not work with large time values?
2) I also need to divide that large time value by a whole number, eg
=21519:51:56/1885
I cannot figure out how to make this happen!
TIA.