how do i add time up in exel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Hi

type out a sample of 5 of your numbers and what you get when you add them
and what you expect.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exel 2003 4
The real Horizontal Formula question 4
How do i obtain an add in called pause in exel? 3
How do I write a formula in Exel that will keep a running count? 2
how can I set up a backdrop in Exel? 1
how to in exel 3
Windows XP In exel how do i 1
dividing a number up evenly into a year 3

Back
Top