New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Formula Needed

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Formula Needed

Postby 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
  • 0

cyran
Rookie
 
Posts: 2
Joined: Apr 13, 2016
Reputation: 0
Excel Version: 2010

Re: Formula Needed

Postby 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
  • 0

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

Re: Formula Needed

Postby 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]
  • 0

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: No registered users and 35 guests

cron