Jul 16 2020 09:25 PM
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??
Jul 16 2020 10:22 PM - edited Jul 16 2020 10:26 PM
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.