Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I was wondering if anybody knows of a formula to allow you to do calculations
based on time. In other words, say I want to put a list of songs on a CD and their durations. Then, I want to add up the durations to get the full time of the CD, or my specific play list. So for example, using the information below: Ghostbusters - Ray Parker Jr. --- 5:23 (Just a guess) Phantom of the Opera Overture --- 3:55 (Another guess) Instead of 8:78, I'd want to see 9:18 Can this be done? Any help would be greatly appreciated. Thank you! -- Have a nice day! ~Paul Express Scripts, Charting the future of pharmacy ~~~~~~ | | |c--OD | _) | | |-. | / `-# /A / /_|..`#.J/ ||LJ `m'' ptaylor |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HOW DO I CALCULATE TIME IN A TIME SHEET FOR EXCEL | New Users to Excel | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
Formula to calculate only the negative numbers | Excel Worksheet Functions |