Thread: Sumation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bikertyke Bikertyke is offline
external usenet poster
 
Posts: 14
Default Sumation

Why when I try to sum 5 days worth of 07:35's does the answer equal 22:00. My
formula {=sum(cell 1:cell 5)*24} I believe is correct as is the formatting,
i've tried time and custom hh:mm.
It should be so simple.