ExcelBanter - how do i sum up a column of time values but ignore negative values

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - how do i sum up a column of time values but ignore negative values (https://www.excelbanter.com/new-users-excel/49805-how-do-i-sum-up-column-time-values-but-ignore-negative-values.html)

Croll

how do i sum up a column of time values but ignore negative values

Advice would be appreciated, thanks

Peo Sjoblom

=SUMIF(Range,"0")

Regards,

Peo Sjoblom

"Croll" wrote in message
...
Advice would be appreciated, thanks

All times are GMT +1. The time now is 01:02 PM.