Learn Excel from Bill Jelen with this daily 2 minute video podcast.
David from Australia sends in a cool trick for adding a timestamp to a spreadsheet. Episode 1106 shows you how.
posted by Bill at 9:00 AM
Today's dueling Excel podcast question is how to count all cells with times greater than five minutes. Episode 1050 shows you how.
Labels: Time
posted by Bill at 9:00 AM
Bill from Washington asks how to track vacation time, specifically times greater than 24 hours and times less than 0 hours. This requires two different tricks. Episode 983 shows you how.
posted by Bill at 9:00 AM
Excel does not deal well with negative times. What if you are tracking vacation time and some employees go into a negative balance? Excel can’t display negative times. However, with the trick in Episode 561, you can coerce Excel into displaying negative times.
Labels: calculation, Time
posted by Bill at 9:00 AM
In honor of Memorial Day in the United States, a question sent in from a naval aviator who has to enter a series of time values. Using a tiny bit of VBA code, we can eliminate the need to type the colon in the middle of the time value. Even if you don’t have to enter times all day, the techniques in Episode 516 can ease the redundant data entry tasks.
Labels: Event Handler, Time, VBA
posted by Bill at 9:00 AM
In yesterday’s podcast, I proposed a formula to solve Jonathan’s dilemma of analyzing information by hourly buckets. An easier solution is to use the Group by Hour feature in a pivot table. Episode 495 shows you how.
Labels: Grouping, Pivot Table, Time
posted by Bill at 9:00 AM
Jonathan from California has a column with date & time information, but would like to strip out just the times to do an analysis by hour. Episode 494 shows you two formulas that can be used to analyze the data by hour.
posted by Bill at 9:00 AM
