Hi, I am trying to resolve an excel issue I have. I am trying to subtract one time value from another time value. I need to account for time spent on certain jobs by my staff. If they are required to perform 4 hours worth of work but actually perform 5 hours and twenty minutes, I am trying to show this overworked time in a spreadsheet but cannot seem to get any joy. Any help would be greatly appreciated. Thanks Tim

Have you formatted your cells [h]:mm. Then you can subtract the later time from the earlier time. As an example Excel interprets 3:00 as 3/24 of a day.(24 hours in a day)To cancel this out do 3:00*24 to cancel out the 24. I hope this helps

If your Start Time is in A1 and your End Time is in B1, this will return the "overtime" worked. For example, a start time of 4:20 and an end time of 9:30 will show 1:10 of overtime. =IF(HOUR(B1-A1)>4,B1-A1-TIMEVALUE("4:00"),0) This assumes that the Start and End times are in the same day. If you cross the mid-night threshold, things get a bit more complicated. Let us know if you need to handle situations like that.