Posted to microsoft.public.excel.misc

JB Bates[_2_] JB Bates[_2_] is offline

external usenet poster

Posts: 36

Converting time to decimal then rounding

Hi

I have a formula

=MOD(T11-R11,1)*24

Where T11 is 22:43 and R11 is 22:34

The difference of these time values is 9 minutes or .15. Currently I am
getting the result of .1 because it is not rounding up. The result I need is
..2 -- so that Excel will round .01 to .04 down and .05 to .09 up.

How should I adjust my formula? Thanks!!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting time to decimal	NoodNutt	Excel Worksheet Functions	4	April 18th 08 06:16 AM
Rounding (decimal) elapsed time	Gilbert DE CEULAER	Excel Worksheet Functions	2	April 4th 08 12:37 AM
converting a decimal to time	dazp1970	Excel Worksheet Functions	3	August 5th 07 09:16 AM
Converting decimal to time	Charlene	Excel Discussion (Misc queries)	17	April 13th 06 08:55 AM
Converting Decimal to Time	Charlene	Excel Discussion (Misc queries)	7	April 11th 06 10:24 PM

All times are GMT +1. The time now is 01:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us