Formulas, Functions, Formatting, Charts, Data Analysis, etc.
by cyran » Wed Apr 13, 2016 8:35 am
Hi.
I am creating an excel spreadsheet for a race. the results are based on the following conditions :
For early arrival, 1 minute penalty per minute early
For late arrival, 10 seconds penalty per minute late
For checking on time, No penal
For late arrival of more than 30mins, the penalty is "OTL"
My columns are as follows :
Column E = Time Intended To Arrive
Column F = Time IN
Please help me with one formula (hh:min:sec) which would calculate the above penalties
Thanks in Advance
Cyran Ojola
-
cyran
- Rookie
-
- Posts: 2
- Joined: Apr 13, 2016
- Reputation: 0
- Excel Version: 2010
by pecoflyer » Wed Apr 13, 2016 10:30 am
Hi and welcome
please post a sample sheet ( no pics please) showing what you have and expected results - Thx
A relevant topic title helps get faster and more answers
-
pecoflyer
- Moderator
-
- Posts: 1274
- Joined: Jan 24, 2012
- Location: Belgium
- Reputation: 39
- Excel Version: 2003/2007/2010
by cyran » Wed Apr 13, 2016 1:24 pm
Hi
A sample would be as follows :
Column E Column F Result
ETA Time IN Penalty
10:00 09:59 00:01:00
10:00 10:01 00:00:10
10:00 10:06 00:01:00
10:00 10:00 00:00:00
10:00 10:31 OTL
The penalty column will contain the formula.
Many Thanks
Cyran
[/color]
-
cyran
- Rookie
-
- Posts: 2
- Joined: Apr 13, 2016
- Reputation: 0
- Excel Version: 2010
Return to General Excel Questions
Who is online
Users browsing this forum: Google [Bot], Google Adsense [Bot], Majestic-12 [Bot] and 59 guests