Excel Magic Trick 299: Date & Time Number - Total Days & Hours Formula
Use the INT function to calculate total days worked and the TEXT function to calculate total hours worked. See the custom number format for total hours past a 24 hour day (hour time format). See how to use the clipboard to gather copied elements for a formula.