LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 447
Default Calculating Time

I was having a few problems calculating the difference of time a few days ago
and I posted some questions and I received a lot of great help. Although,
I'm still having problems. I'm not sure if I reply to a message in that old
post, if anyone will see it. Not sure how that works. Therefore, I'm
posting a new message.
This is what I have:

I don't understand why I'm getting different results when I do a paste
special. When I paste the time formula into certain cells, the result is
fine.
Then when I paste the formula into another cell, I'm getting a result of
16.9999999999999 and Excel will not allow me to decrease the decimals places.
Why is this happening and how can I get a result of 17 min.?

Cell F18 = 10:17 AM
Cell D18 = 10:00 AM
Cell H18 = The formula is: =(((F18-D18)*60)*24)&" min."
Result in H18 = 16.9999999999999

HELP!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Calculating time increments from dates during working hours S Davis Excel Worksheet Functions 0 October 24th 06 03:32 PM
calculating time T.K.RAJU via OfficeKB.com Excel Discussion (Misc queries) 3 December 27th 05 12:22 PM
help with calculating overtime in a time sheet jongyrocka Excel Discussion (Misc queries) 13 December 10th 05 09:36 PM
Calculating a rate for elapsed time? Keith Excel Discussion (Misc queries) 8 May 18th 05 09:14 PM
Calculating tvl time in Excel 2000 Rev.9.2720 Brandi Excel Worksheet Functions 5 January 27th 05 09:15 PM


All times are GMT +1. The time now is 06:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"