Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
FormattingPosted by Tim on June 14, 2001 12:29 PM
I am using the above formula in a cell. The a4 cell
contains the following: 15656:30:00 in a custom format
I keep getting a #value in A1(where the formula is.
any reason why??
|Check out our Excel Resources
the problem appears to be in the 15656:30:00 format Posted by Eric on June 14, 2001 1:54 PM
Sorry I can't be of more help. Your formula works with ordinary time formats (and, in fact,with the custom format you're using, so long as the time conforms to a standard format- e.g 24 hour or 12hour AM PM). In fact all of the individual formulas, =hour, =minute, and =second give the #value error on your 15656:30:00 data. What does 15656 represent?
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.