Excel Magic Trick 299: Date & Time Number – Total Days & Hours Formula

Excel Magic Trick 299: Date & Time Number – Total Days & Hours Formula

HomeOther ContentExcel Magic Trick 299: Date & Time Number – Total Days & Hours Formula
ChannelPublish DateThumbnail & View CountActions
Channel Avatar excelisfun2009-03-23 19:05:18 Thumbnail
114,756 Views
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.

Please take the opportunity to connect and share this video with your friends and family if you find it useful.