Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 07-18-2015, 10:02 AM
Sekerob Sekerob is offline Convert large seconds values to a time format fails with #Value Windows 8 Convert large seconds values to a time format fails with #Value Office 2013
Novice
Convert large seconds values to a time format fails with #Value
 
Join Date: Jul 2015
Posts: 6
Sekerob is on a distinguished road
Default

Thanks for your reply. Saw the mail notification earlier and played with your 'improved' version. Now it's 146 char long from before 160 and substituted the old whereever it showed in the workbooks.

Bug or feature, I've been unable to derive where 255611462399 seconds might have been coming from.

Pity your MS MVP crystal ball is as hazy as mine with regards to what's being fixed. Maybe I'll have a look at the OF2015 test release. Curious is, if using d:hh:mm:ss as text mask, the feedback value is 31:23:59:59 or 32 days minus 1 second. Did not find [d]:hh:mm:59 as working. Pity as that would have allowed to reuse the days determined... 2958100 it seems.

Anyway, Thx again.
Reply With Quote
 

Tags
time format



Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert alphabets to numeric values kjxavier Word 3 07-06-2014 05:34 AM
Convert numeric values with decimals to alphabets kjxavier Word 1 07-06-2014 01:44 AM
Convert large seconds values to a time format fails with #Value PDF converter fails to convert equations Jennifer Murphy Word 3 01-12-2012 02:57 PM
Adding a long column of time increments in seconds klippert Excel 1 09-18-2010 12:26 AM
Is there a way to change the header in a large amount of documents at one time? ntsstaffing Word 1 07-11-2009 12:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft