how do i add time up in exel

L

loadie

everytime i use =sum(a1:a30)*24 i keep getting an odd number even though i
only enter even numbers ,this is to add my hours worked in a month
 
F

Fred Smith

Tell us what's in a1:a30. If they are all even numbers, you should
definitely get an even result. But if they include minutes, you can get an
odd number of hours.
 
J

JulieD

Hi

type out a sample of 5 of your numbers and what you get when you add them
and what you expect.
 
Top