How can I have Word or Excel automatically calcluate the sum of time values provided in this format? 08:00 AM to 4PM (Monday through Friday) Saturday 12:00 to 4:00 PM I need total hours calculated automatically with one of these applications. I looked at the VB functions in word and found nothing. Thanks.

I looked in Excel, and it supports time formats, but I'm not sure if it can do exactly what you want, because I'm not sure what you're asking. The sum of two times... how do you add 8:00AM to 3:00PM? Do you mean the time between them and some other set of values? For example, do you want to add the difference of two sets of times? ie: 8:00AM to 12:00PM + 3:00PM to 4:00PM = 5 hours. Is that what you mean? If you're going to do this in Excel, then there really isn't a limit on what you can do. It's built in functions allow you to take cell values apart and manipulate them in so many ways that you shouldn't even need to use VBA unless you want/have to.

Sorry for not being clear. Sample data that I want to add for a total sum: Mon 0800 0200 Tues 0800 0230 Wed 0800 0200 Sat 0745 0445 Total Hours xxx I need the sum of the total hours of all the rows. Also, the hours will NOT be listed in military format so 3:00PM =3:00PM and not 15:00 hours. Only interested in hour and minute totals. Thanks.

The formating is done by edditing the format of the cell your working with. There is an inbuilt function in excell called Average - =AVERAGE(A1:A10) would run a total of all values in A1, A2, A3 etc to A10 and then divide by the number of cells in the formula - try that