I have a new position and have been asked to assist in day sheets. I need to calculate how much time is spent in travel and services by line. One column will have begin time and the next column will have end time. I need to calculate the time spent on that item. I bought books on excel but don't think I have time to learn what I need to know in time to have the job on track. The column calculating the time spent will have to be in hour and minutes. Example: 3:15 (begin time) 4:00 (end time) the calculating column would read 45 (showing minutes) and if longer than minutes show 1hour and 45 minutes. I need to keep to hours since most employees do not relate to military time.

time is of the essence.

Thank you

Fbggirl