Hours worked
Work out the hours between the start (B) and finish (C) times in column D.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Write “Hours” in D1
- Hours formula in D2:D1000
- Total hours into D1001
Use it in MacroRoni: open the Starter gallery, search for "Hours worked", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More dates & time macros
Dates & timeAge from date of birthWork out each person's age in years from the birth dates in column B, in column C.Changes data · backup onDates & timeDays until dueCount the days from today until each due date in column C, in column D.Changes data · backup onDates & timeDays overdueShow how many days each due date in column C is late (0 if not late), in column D.Changes data · backup on