Forum Home
Press F1
 
Thread ID: 3806 2000-03-16 06:37:00 Adding up hours and minutes in Excel 97 Guest (0) Press F1
Post ID Timestamp Content User
4242 2000-03-16 06:37:00 I'm trying to keep a track of how much time I spend on various as pectts of my work. So, during the day I make voice recordings such as 'Job X 35 minutes, Job Y 1 hour 15 mins' etc.

A) how should I enter these into a spread sheet (can't seem to find anything in the FORMAT CELLS option and, more importantly, B) how do I get it to add up the day's work automatically (bearing in mind that eg 200 minutes needs to be converted to 3 hours 20 mins in order for the calculation to work properly)
Guest (0)
1