I have a monthly timesheet with a different sheet for each month. I would like a running total of the amount of sick leave/personal leave I have used. I have the formula as =Sum(AUG:MAY!H5:H28) AUG being the name of the first sheet and MAY the name of the last. The column with sick leave is column H with cells 5 through 28 having possible hours. I receive no errors with the formula but the hours are not adding up correctly. Am I missing something obvious?
TIA.
Last edited by shg; 04-23-2009 at 08:38 PM.
are all the cell values real numbers not text numbers? it wont add text numbers
Last edited by martindwilson; 04-23-2009 at 07:11 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
All values are time hh:mm.
ok you are adding times
use
=Sum(AUG:MAY!H5:H28)*24
format cell as general
that should give a real total of hours
see attached for examples
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks