Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I've been fiddling and fiddling for some time now this evening but I
seem to be missing something completely today. In the past I've dealt with adding/subtracting times formatted the same way as the end results, so they've worked from the get-go. In today's case, I have a spreadsheet that I'm using to calculate best fits for movies transferred from VHS to DVD via a DVD Recorder. My DVD Recorder deals with hours and minutes but my internet source gives total running time in minutes only. How do I get Excel 2000 to add up a column of minutes and then give the results in a time formatted as hours and minutes? If I could get this to work, I could then just plug in different movie running times finding best fits? Thanks! I'm in the corner with my dunce cap, I can't figure out my approach today in a way that works. :oD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding hours and minutes | Excel Worksheet Functions | |||
Sum minutes and seconds to total hours | Excel Discussion (Misc queries) | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Adding minutes to time | Excel Discussion (Misc queries) | |||
add column of minutes, show total in hours & minutes | Excel Worksheet Functions |