| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to round the time to the nearest quarter hour. Help
Hi, I am trying to get my spreadsheet to round to the nearest quarter hour.
This is the current formula I am using. =ROUND(IF((OR(B15="",C15="")),0,IF((C15<B15),((C15-B15)*24)+24,(C15-B15)*24))+IF((OR(E15="",F15="")),0,IF((F15<E15),(( F15-E15)*24)+24,(F15-E15)*24)),2) As you can see it to decemal with breaks included. I still need to finnish in decemal. I tried to incorpuate a couple of formulas but fail. =ROUND(A1*96,0)/96 =ROUND(D13*4,0)/4 Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to round the time to the nearest quarter hour. Help
I figure it out. Thanks
"John" wrote: Hi, I am trying to get my spreadsheet to round to the nearest quarter hour. This is the current formula I am using. =ROUND(IF((OR(B15="",C15="")),0,IF((C15<B15),((C15-B15)*24)+24,(C15-B15)*24))+IF((OR(E15="",F15="")),0,IF((F15<E15),(( F15-E15)*24)+24,(F15-E15)*24)),2) As you can see it to decemal with breaks included. I still need to finnish in decemal. I tried to incorpuate a couple of formulas but fail. =ROUND(A1*96,0)/96 =ROUND(D13*4,0)/4 Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time sheets | Excel Worksheet Functions | |||
| How do I calculation time in excel in 24 hour method | Excel Discussion (Misc queries) | |||
| How do i round up a price to the nearest 5,10,15 etc pence | Excel Worksheet Functions | |||
| WHAT SYNTAX IS USED TO ROUND A 4-DIGIT NUMBER TO THE NEAREST THOUS | Excel Discussion (Misc queries) | |||
| how do you subtract military time? example 12:00 - 07:00 = 5 hour. | Excel Worksheet Functions | |||
Hybrid Mode
