Rounding Time
 

=
Mod(round(d7*96,0)/96-round(c7*96,0)/96,1)+Mod(round(d8*96,0)/96-round(c8*96
,0)/96,1)+Mod(round(d9*96,0)/96-round(c9*96,0)/96,1)

Regards,
Tom Ogilvy


"Matt" wrote in message
...
I have six cells that record times in military time and add up a total for
time records. Right now I have a formula that subtracts one cell from
another and then rounds that time to the nearest quarter hour. I have
three
sets of cells that I add together to come up with a total. I want to
round
each individual cell and then subtract instead of subtracting and then
rounding. Here is the formula that I have right now. Any help would be
great. Thanks in advance. Matt

=ROUND((MOD(D7-C7,1)+MOD(D8-C8,1)+MOD(D9-C9,1))*96,0)/96