Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IN EXCEL, ROUND 10.45 T0 10.5 OR 10.27 TO 10.25
TRYING TO ROUND TIME EQUATIONS TO THE NEAREST QUARTER HOUR. FIGURED OUT HOW
TO DETERMINE THE HOURS BETWEEN STARTING AND STOPPING TIMES, BUT WANT TO ROUND THE RESULTING HOURS TO NEAREST QUARTER HOUR. |
#2
|
|||
|
|||
IN EXCEL, ROUND 10.45 T0 10.5 OR 10.27 TO 10.25
Refrain from using all caps, it is considered rude
=ROUND(A1*96,0)/96 -- Regards, Peo Sjoblom (No private emails please) "JOE T" <JOE wrote in message ... TRYING TO ROUND TIME EQUATIONS TO THE NEAREST QUARTER HOUR. FIGURED OUT HOW TO DETERMINE THE HOURS BETWEEN STARTING AND STOPPING TIMES, BUT WANT TO ROUND THE RESULTING HOURS TO NEAREST QUARTER HOUR. |
#3
|
|||
|
|||
IN EXCEL, ROUND 10.45 T0 10.5 OR 10.27 TO 10.25
In your example: 10.5 means half past ten and 10.25 means quarter past
ten? 10.45 is 27 minutes after ten? If so you'd rather use: =ROUND(D13*4,0)/4 Regards, Tomek Polak, http://vba.blog.onet.pl |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
how do I get excel 2003 to round up | Excel Worksheet Functions |