Hi, How can I add time (format hh.mm) without limitation? Thanks Erick
D David McRitchie Jul 24, 2005 #3 Hi Erick, As long as your sum also has the format [h]:mm you should have no trouble adding up cells and no rolling over of hours into days. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm Erick said: posted too quickly.... format is [h]:mm thanks any way Erick Erick said: Hi, How can I add time (format hh.mm) without limitation? Thanks Erick Click to expand... Click to expand...
Hi Erick, As long as your sum also has the format [h]:mm you should have no trouble adding up cells and no rolling over of hours into days. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm Erick said: posted too quickly.... format is [h]:mm thanks any way Erick Erick said: Hi, How can I add time (format hh.mm) without limitation? Thanks Erick Click to expand... Click to expand...
