Add times and genral numbers

J

John

I have a spread sheet that calculates a score based on the time to
finish an event PLUS points scored during the event.

Currently I enter the times as seconds (general number Eg 2 minutes =
120. This allows for easy adding of time and points.

Each second of event time counts as 1 point. Eg 2 Minutes 30 Seconds
is 150 points PLUS 50 points scored during event for a total of 200
points.

I want to be able to add times in the correct format. Eg 2:30 for 2
minutes 30 seconds instead of using 150 seconds (actually I would
prefer 2.30 for speed)

How can I do this to allow for adding a time of 2:30 AND 50 points to
get a total 200

Regards
John
 
N

Norman Harker

Hi John!

If you enter in time format (0:2:30) you can use:

=A1*24*60*60+50

If you enter as 2.30 you can use:

=INT(A1)*60+MOD(A1,1)*100+50

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
J

John

Norman Harker said:
Hi John!

If you enter in time format (0:2:30) you can use:

=A1*24*60*60+50

If you enter as 2.30 you can use:

=INT(A1)*60+MOD(A1,1)*100+50

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Click to expand...

Thanx
Simple when I now look at it. Thank you for the quick input.

John
 
N

Norman Harker

Hi John!

Thanks for thanks and confirmation that solution works as advertised.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top