Multiply h:mm:ss?

[mcintoshmc]

I am trying to multiply 0:35:15*1000 and I keep getting the result of 11:30:00. What am I doing wrong?

 

[PCL]

Which result you were expecting ...?
With 00:30:15 you get 00:10:00

 

[Joe4]

Try changing the cell format to:

[h]:mm:ss

if you want total hours, minutes, seconds.

It is important to understand how Excel stores date anf time. It stores dates as whole numbers, specifically the number of days since 1/0/1900. So time is just a fractional component of one day.
So, your multiplication is returning the right value, but the wrong format (or more accurately, not the format you are expecting).

 

[mcintoshmc]

Which result you were expecting ...?
With 00:30:15 you get 00:10:00

If it takes 35 minutes and 15 seconds to build something, and you have to build 1000 of them, it will take longer that 11 hours and 30 minutes to build.

 

[mcintoshmc]

Try changing the cell format to:

[h]:mm:ss

if you want total hours, minutes, seconds.

It is important to understand how Excel stores date anf time. It stores dates as whole numbers, specifically the number of days since 1/0/1900. So time is just a fractional component of one day.
So, your multiplication is returning the right value, but the wrong format (or more accurately, not the format you are expecting).

Thank you that worked. I had it set to h:mm:ss instead of [h].

 

[Joe4]

Your are welcome.

Yes, that returns a 24 hour clock, so it keep starting over.
If you add a date component, it will show the number of days (January 24, 1900, indicating 24 days) and then the leftover time after that.

So they are all correct, it is just how you want to present the results, which is all controlled by formatting.