Hi

I have a colum of 514 rows with hours information (15:00, 0:30, etc). I
want to get the maximun number of hours within this range. I have used the
formula =max(a1:a514) but the outcome is 0:00. I have done this calculation
before with hours and it has worked. The ranges have been smaller, though.

Could anyone help me to figure out how to do it or why it is not working?

Thanks,
Orquidea