time !

[Rick Merrill]

I want o add up Time codes that are for 24 hours

The time codes are of the form
00001506

which means 15 seconds and 06 hundredths of a second.

obviously the problem is that the 'seconds' and the 'minutes'
fields are modulo 60 and the 'hours' field is modulo 24.

Thanks in advance!

 

[JE McGimpsey]

One way:

=(LEFT(A1,2)+MID(A1,3,2)/60 + RIGHT(A1,4)/360000)/24

 

[Niek Otten]

=TIME(LEFT(A1,2),MID(A1,3,2),MID(A1,5,2))+RIGHT(A1,2)/24/60/60/100

Format Custom as hh:mm:ss.00

Now you can add and it will follow "your" rules.

 

[Rick Merrill]

=TIME(LEFT(A1,2),MID(A1,3,2),MID(A1,5,2))+RIGHT(A1,2)/24/60/60/100

Format Custom as hh:mm:ss.00

Now you can add and it will follow "your" rules.

gREAT!

 

[daddylonglegs]

Here's a simpler way.....

=TEXT(A1,"00\:00\:00\.00")+0

format as hh:mm:ss.0

 

[Rick Merrill]

Here's a simpler way.....

=TEXT(A1,"00\:00\:00\.00")+0

format as hh:mm:ss.00

So the "+0" forces it to a number?

 

[daddylonglegs]

So the "+0" forces it to a number?

That's right, you could just as easily use

=--TEXT(A1,"00\:00\:00\.00"

 

[daddylonglegs]

So the "+0" forces it to a number?

That's right, you could just as easily use

=--TEXT(A1,"00\:00\:00\.00"