Link to home
Create AccountLog in
Avatar of john-formby
john-formbyFlag for Ghana

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
ASKER CERTIFIED SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of nand633
nand633

For 61.11 minutes, which format will you prefer:

61:07

61:06.6

1:01:07

1:01:06.6
Avatar of john-formby

ASKER

Thank you so much, that works perfectly