Help with time formats in Excel 2007,

B

barteec

Everyone, I am trying to display a hh:mm:ss time format to depict a tru
time within a year. The data that I download gives me raw data in a tim
format of HH:MM:SS. I can put in excel using the [h]:mm:ss custom forma
to show correctly. The problem that arises is when I sum all the data
the total could be more that a total time in a year.

You can see in my example the time format and the last row is th
summation of all above. I want to show each row in a format that woul
depict the true hours:min:secs of total time within a year.

I have tried this:
= (MID(A1,1,8))*1440 , but this shows total mins

=A1*24 , but not sure is this is correct?


A1
9:01:55
13:53:23
32:06:30
113:39:32
466:59:43
499:02:54
829:48:32
869:18:54
1502:20:32
1631:15:48
2030:51:25
3296:19:45
3378:58:24

14673:37:1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top