Formula sum

Occasional Visitor

How do I change the way a row sums...??? Example: the cells are in 15 min increments as .15. How do I get the sum to turn whole at 60 instead of 100?? Does that make sense??

1 Reply

One possibility. Change range reference as needed: =SUMPRODUCT(TIME(INT(A1:A10),100*MOD(A1:A10,1),0))

 

You can use the traditional time format (h:mm) or use a custom number format h.mm if you want to continue using a decimal instead of colon to separate hours and minutes.