Excel Magic Trick 1250

DESCRIPTION

Add Times to Get Total Minutes & Seconds From Downloaded Music Data
Learn how to add times to show total minutes and seconds for copy and pasted downloaded music data. Learn about Time Math, Time Number Formatting and How to shows hours greater than 24 hours:
(00:11) Problem Introduction
(01:13) Learn about Time Number Formatting and the Time Values Excel stores under the Time Number Formatting
(03:15) See how standard Time Number Format ca NOT show hours greater than 24 hours
(04:09) Learn the Custom Time Number Formatting to show hours greater than 24 hours: [hh]:mm
(05:01) Learn how to Convert Hours To Minutes and Convert Minutes to Seconds
(06:03) Solution #1: Add times with SUM function and use the Custom Time Number Formatting: [hh]:mm. This solution displays the correct value, but the time value is in hours.
(06:34) Solution #2: Add times with SUM function and divided by 60 (=SUM(B2:B5)/60), then apply the Time Number Formatting: hh:mm:ss. This solution gives the correct time value.
(07:51) Solution #3: Add times with SUM function and use the Custom Time Number Formatting: [hh] “minutes” mm “second”. This solution displays the correct value, but the time value is in hours.
(09:02) Solution #4: Formula for actual minutes and whole numbers: =INT(SUM(B2:B5)*24)
(09:56) Solution #5: Formula for actual seconds and whole numbers: =MOD(SUM(B2:B5)*24,1)*60

WORKBOOKS




Be the first to comment

Leave a Reply