View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default Adding all the variables

I'm constructing a spreadsheet that uses time entries such
as 11:00, 11:00A, 11:00B, etc. How do I create a formula
that I can use to sum all of these entries in a range?


If all your entries (including the 11:00) are text, and if times before
10:00 are formatted with leading zeros, then try this...

=SUM(TIMEVALUE(LEFT(A12:A14,4)))

You would commit this formula by using Ctrl+Shift+Enter (not just Enter by
itself).

If you have some different conditions than assumed above, please tell us
what they are.

Rick