I need to create an Excel spreadsheet (2000 ver) where I can enter hours and minutes in separate cells, then have them total
up all together as hours and minutes.
I've been given the task of having to calculate all the time I've spent on
certain projects, so the number of hours/mins to calculate will change over time as I add/subtract time.
to illustrate in an example:
34 65 <--- Totalling columns as general numbers
35 5 <--- The result I want to display
I've never had to make a formula in a spreadsheet other than "=sum(cell:cell)" so I have no idea how to go about
I'm sure for an experienced Excel user, this is a no-brainer. Did I also mention that I suck at math?!