john-formby

asked on

# Excel show number as minutes

Hi,

I have an Excel spreadsheet where I calculate how many minutes it takes a group of people to unload a certain weight from a truck. I have calculated the following:

Each person can unload 2.6 tons per hour

This equates to 43.4KG per minute

Ton unload 1 ton, it would take (1000KG/43.4KG) 23.04 minutes

For a group of 12 people, it would take (23.04/12) 1.92 minutes

What I want to do is find a way to express the 23.04 minutes and 1.92 minutes as actual MM:SS.

I have tried changing the number format to Time, but this does not work. Is there a way to do this?

Thank you for looking,

John

I have an Excel spreadsheet where I calculate how many minutes it takes a group of people to unload a certain weight from a truck. I have calculated the following:

Each person can unload 2.6 tons per hour

This equates to 43.4KG per minute

Ton unload 1 ton, it would take (1000KG/43.4KG) 23.04 minutes

For a group of 12 people, it would take (23.04/12) 1.92 minutes

What I want to do is find a way to express the 23.04 minutes and 1.92 minutes as actual MM:SS.

I have tried changing the number format to Time, but this does not work. Is there a way to do this?

Thank you for looking,

John

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

ASKER

Thank you so much, that works perfectly

61:07

61:06.6

1:01:07

1:01:06.6