mm:ss formatting

levy77

Board Regular
Joined
May 7, 2019
Messages
67
Does anyone have a solution to formatting mm:ss without the AM/PM after it. I'm creating a spreadsheet where I need to put time as an input, say for a race where something like 10:30 would be 10 minutes and 30 seconds. There are then some calculations done on the time which says if time is below 10 minutes the person gets 20 points, if above 20 minutes the person gets 0 points then uniformly distributed for all other values between 10 and 20 minutes. The cutoff points will also be dynamic, so that you could change the lower bound to something like 12:30, which would be 12 minutes and 30 seconds.

Is there also a way once the formatting is correct, to apply data validation so that the person must enter mm:ss exactly?

This sheet will be spread to a large number of different computers so I wont be able to just change the computers default time setting as this will be redundant when other people open the sheet.

Does anyone have any suggestions or direction?

Cheers.
 
sure, but in this case you cannot calculate time automatically and you'll need some formulas to do that
ok if it works for you
have a nice day
 
Upvote 0

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Forum statistics

Threads
1,213,560
Messages
6,114,304
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top