View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Adding hours minutes and seconds

Even if you format the column as hh:mm:ss then entering 030528 will
still see this as a date.
You need to have two columns, one to enter the data in the form you
want to and a second one wich you format to automatically display this
as a time.

Suppose you enter the data in A1, use this formula in B1:

=TIME(VALUE(LEFT(TEXT(A1,"000000"),2)),VALUE(MID(T EXT(A1,"000000"),3,2)),VALUE(RIGHT(TEXT(A1,"000000 "),2)))

To get a running total of column B use this in B1 and copy into B2 etc.

=SUM($B$1:B1)

But be careful, this will only display values upto 24 hours and then it
will start with 0 again!

Hans