Archive of Mr Excel Message Board


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

Formatting

Posted by Tim on June 14, 2001 12:29 PM
=SUM(HOUR(A4),MINUTE(A4)/60,SECOND(A4)/3600)

I am using the above formula in a cell. The a4 cell
contains the following: 15656:30:00 in a custom format
[h]:mm:ss

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.