LinkBack URL
About LinkBacks
You've encountered the rounding error from floating point arithmetic. Try this:
=ROUND(B1-A1,5)*24
You've encountered the rounding error from floating point arithmetic. Try this:
=ROUND(B1-A1,5)*24
Last edited by ConneXionLost; 02-03-2014 at 04:25 PM.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Hi,
That returns 24:00 when taking 17:00 from 18:00 ? My apologies if I'm missing something, I am trying to get a return of one hour
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks