mark_hassall
New Member
- Joined
- May 21, 2018
- Messages
- 1
Hi,
This is two questions in one, but they're linked:
I want to record a time duration in MM:SS into a cell. I've set the format using "custom" and "MM:SS", but to get it to display properly I have to enter zero values for the hour, e.g. 00:10:32 to display 10:32. Is there a way to avoid having to enter the zeros?
Secondly, the target duration is 10 minutes. I then want a second cell to display a penalty score if the time is more or less than 10 minutes using the following rule:
10 point penalty for each whole minute the time is over 10 minutes up to a maximum of 40 penalty points.
10 point penalty for each whole minute the time under 10 minutes up to a maximum of 20 penalty points.
I've been trying to write an "if" statement for this, but haven't succeeded yet, does anyone have any suggestions?
Thanks
Mark
This is two questions in one, but they're linked:
I want to record a time duration in MM:SS into a cell. I've set the format using "custom" and "MM:SS", but to get it to display properly I have to enter zero values for the hour, e.g. 00:10:32 to display 10:32. Is there a way to avoid having to enter the zeros?
Secondly, the target duration is 10 minutes. I then want a second cell to display a penalty score if the time is more or less than 10 minutes using the following rule:
10 point penalty for each whole minute the time is over 10 minutes up to a maximum of 40 penalty points.
10 point penalty for each whole minute the time under 10 minutes up to a maximum of 20 penalty points.
I've been trying to write an "if" statement for this, but haven't succeeded yet, does anyone have any suggestions?
Thanks
Mark
