Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home


Posted 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
All contents © 1998-2004
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.