my system crash and I could not recover the reply someone sent for this problem I am having. I tried to add minutes to hrs and minutes in excel. The hrs and minutes are in one cell and the minutes by itself are in another cell. Excel won't recognized the minutes by itself. I am working in a time format and when my total is over 24 hrs it will not compute it correctly. any ideas.. thanks

While this is a Vista forum not Office, for which there is a seperate forum, I can only suggest that you add hours in one column, minutes in another, the hours column total formula could be: Column A hours C minutes and row 10 the total =SUM(A1:A9)+C10/60

thanks. I can change to Office if there were a better way of doing this. I am adding the downtime of several employee's each month. Having to use a seperate column for hrs and another for minutes may confuse others when I'm not there.

As I sample the function =SUM(A1:A9)+C10/60 it is not 100% accurate. For example if I enter the number "2" in column A for all nine cells and then enter the number "15" in column "C" the total number displayed is 20.25