find sum of start time and end time in excel

Microsoft Excel 2003 (full product)
December 30, 2010 at 14:39:13
Specs: Windows XP
I have a problem with the time sheet I created in excel for recording downtime. I am using the custom: h:mm AM/PM for start time / end time and then using h:mm for total time. The formula is a very basic =sum(c2-b2) This works well until I have a start time before midnight and an end time after midnight. Any help with this would greatly be appreciated. Thanks in advance

See More: find sum of start time and end time in excel

Report •

#1
March 5, 2011 at 06:27:43
Even I have same problem........can any one please help

Report •
Related Solutions


Ask Question