Have you tried wrapping the ABS function around the Sumif function?
Where X1 and X2 houese date values.
You need to highlight the range and using Formula Is,
=($A1 < "7/15/2008"+0)*($A1<>"")
Thanks for the link! :up:
I help run a junior golf program and use Thunderbird as my email program. Is there anyway i can create a "gouping" so I can include several...
Thanks guys! I also found out you can use,
I'll mark this solved. Thanks again!
I've used tables for fill in forms in Word 2003. When I print, I do not want the table to be printed. Is this possible?
For times crossing over to the next day use,
where A1 is start time B1 end time.
When you add 1440 in your formula, you're...
Format the cell that houses the formula as
For times running into the next day, try,
Where A1 is start time, B1 end time.
You can use Data Validation as an option. As an example, your 10 fields to input are A1:A10. Highlight the range, go to Data/Validation, in the...
Multiply by 24 and format as a number....;)
See the Help files for the N function,
Separate names with a comma.