|
|
Featured Tutorial
Featured Macro
YouTubersLoveExcel#24: Add Time by Hour, Minute or Day
See how to use formulas to add any unit of time that you would like. Add a column of time values with units of Hours, Minutes, or Days.
1) Time In Hours = (Time Out -- Time In)*24
2) Time In Minutes = (Time Out -- Time In)*24*60
3) Time In Days = Time Out -- Time In
1) Time In Hours = (Time Out -- Time In)*24
2) Time In Minutes = (Time Out -- Time In)*24*60
3) Time In Days = Time Out -- Time In