gentlemen and scholars...I am looking for some advice. I have a spreadsheet where my crews log in and log out at each site. this is done in 24 hour format. I have a separate column cell where I would like to calculate the total time spent on site...or time out minus time in. preferable I would like this total to be in minutes. I can get a value in hours and minutes IF my time out is greater than my time in. for example...time in is 07:30...time out is 08:45 my total is 1:15. however,. if my time in is, say, 9:50 and my time out is 1:30 I get no value in my total cell...it says "dates and times are negative or too large to display as ######.
thanks in advance! oh...Office 2010
Bookmarks