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
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