Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding off time | Excel Worksheet Functions | |||
Time and rounding | New Users to Excel | |||
Rounding Time? | Excel Worksheet Functions | |||
Rounding Time | Excel Discussion (Misc queries) | |||
Rounding Time? | Charts and Charting in Excel |