cells are formatted to [h]:mm and will not use a number higher than 9999:56
B Biff Mar 27, 2006 #2 Hi! You can manually enter time values up to 9999:59, above that they are automatically evaluated as GENERAL TEXT values. You can calculate time values well in excess of 9999:59 A1 = 9999:59 A2 = 9999:59 =SUM(A1:A2) Returns 19999:58 Biff
Hi! You can manually enter time values up to 9999:59, above that they are automatically evaluated as GENERAL TEXT values. You can calculate time values well in excess of 9999:59 A1 = 9999:59 A2 = 9999:59 =SUM(A1:A2) Returns 19999:58 Biff
P Peo Sjoblom Mar 28, 2006 #3 Use this technique, assume you have 35523 hours and you want to add 11450 hours to that, use =(35523/24)+(11450/24) or if you have the times in cells A2:A3 =SUM(A2:A3)/24 returns 46973:00:00 formatted as [hh]:mm:ss -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon
Use this technique, assume you have 35523 hours and you want to add 11450 hours to that, use =(35523/24)+(11450/24) or if you have the times in cells A2:A3 =SUM(A2:A3)/24 returns 46973:00:00 formatted as [hh]:mm:ss -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon
