In this week's Office challenge, test your Word skills and learn the solution to last week's Excel challenge.
Word lets you add captions to document images and the feature's somewhat versatile. You can position the caption above or below the image. What you can't do, using captions, is position text on top of the image, but it can be done. How would you do it?Last week, we asked…
Come up with a formula that subtotals elapsed time by the day and you guys provided a number of efficient and creative formulas. First, as Oldbaritone mentions, if you store the date and time together, the problem of elapsed time completely disappears. However, most users don't want to be bothered—force them to enter the date more than once and they'll complain. In the defense of complaining users, while including the date in both the Start and End time is precise, inputting the date twice is a bit inefficient, especially if users are tracking several projects each day. Several of you offered formulas that are close cousins to my choice, which takes the following form:
=End-Start + (Start > End)
If Start is larger than End, you know that the period extends into the next day. The (Start > End) component adds 1, which eliminates the error. When both times fall within the same day, the added component is False, or 0. This formula does the same thing so many of you expressed, it's just a tad shorter, and for me, easy to remember.
In this respect, Kent Lion is absolutely correct—the example sheet is in error by allowing only one date. A real time-tracking spreadsheet would most likely be more complex and precise. Yet, I see this simple time-tracking technique frequently. If time periods never extend into a third day (over 48 hours), this simple setup is usually adequate.
Now, on to the running total formula; I like Joaquim's formula:
This formula uses SUMIF() to specify criteria. If the dates in column A match, do nothing. If they don't match, sum those that do match. It's elegant and after testing, I can find no flaw in it and it's shorter than the formula I had in mind!