MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Adding numbers to hh:mm:ss


Posted by Jas S on February 11, 2002 8:46 AM

I have a spreadsheet which has a custom cell (hh:mm:ss) and a general cell which has a value in minutes. I would like to add the contents of the two cells together to get the answer in hh:mm:ss. Can anyone help please? Thanks..Jas


Posted by Aladin Akyurek on February 11, 2002 9:03 AM

=A1+B1/1440

where A1 is a time in hh:mm:ss and B1 houses the number of minutes to add.

Posted by Jas S on February 11, 2002 9:13 AM

Thanks Aladin