Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i add time up in exel
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 |
#2
|
|||
|
|||
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. -- Regards, Fred Please reply to newsgroup, not e-mail "loadie" wrote in message ... 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 |
#3
|
|||
|
|||
Hi
type out a sample of 5 of your numbers and what you get when you add them and what you expect. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "loadie" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Sheets | Excel Discussion (Misc queries) | |||
unmet challenge | Excel Worksheet Functions | |||
Summing Time | Excel Discussion (Misc queries) | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |