Log in
Register
Menu
Log in
Register
Home
What's new
Latest activity
Authors
Forums
New posts
Search forums
What's new
New posts
Latest activity
Members
Current visitors
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
General Topics
Members Lounge
The Meeting Place
Excel and Time Calculations
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="w hole" data-source="post: 1674" data-attributes="member: 175048"><p>Hello All</p><p></p><p>Yes it has the same effect at the entry I was using, problem is it won't subtract an hour from anything between 00:00 and 00:59.</p><p></p><p>I tried adding 23hrs, it gives the correct value in the cell, but because it actually stores a date and time even though only the time is displayed, it messes up the sorting.</p><p></p><p>I'm sure the answer is in there somewhere, even if it means sorting on the original times rather than the conversions, but it looks like a bit more trial and error, unless someone knows better.</p><p></p><p>Thanks again for the input, must get off to see Letterman, then early start Friday, so will have another think tomorrow.</p><p></p><p>Regards</p><p></p><p>W Hole.</p><p></p><p>PS. 2old, any idea why Letterman is no longer on V8?</p></blockquote><p></p>
[QUOTE="w hole, post: 1674, member: 175048"] Hello All Yes it has the same effect at the entry I was using, problem is it won't subtract an hour from anything between 00:00 and 00:59. I tried adding 23hrs, it gives the correct value in the cell, but because it actually stores a date and time even though only the time is displayed, it messes up the sorting. I'm sure the answer is in there somewhere, even if it means sorting on the original times rather than the conversions, but it looks like a bit more trial and error, unless someone knows better. Thanks again for the input, must get off to see Letterman, then early start Friday, so will have another think tomorrow. Regards W Hole. PS. 2old, any idea why Letterman is no longer on V8? [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
General Topics
Members Lounge
The Meeting Place
Excel and Time Calculations
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.
Accept
Learn more…
Top
