As part of my job now I have to ensure that some of our residents don't exceed our limit of 65hours out of our facility. We basically write on a weekly calendar sheet from sunday to saturday when they leave and return (in military time format). Is there an easy formula in excel or a webpage that allows me to calculate the difference daily and total for the week? I'm not much of a computer guru but I don't want to calculate these by hand if needed. I just want something quick and easy that I can blaze thru hopefully entering their leave time like 1530 and their return time like 2243 and getting a diff and having it totaled in hours/min. Edited to correct my horrible in the middle of the night spelling!