Add values to time formatted cells
I have a problem with a car race i'm trying to time.
I have got the net time with a time formatted cell. Though they may incur penalties that add 10secs onto the net time.
I have created a column with the number of penalties but am struggling to convert these into a time format to then add to the overall time? At moment i'm inputting it manually but am after a formula or format to convert it automatically?? I've attached my current sheet and highlighted column. There is a 10sec penalty for each flag hit.
Thanks in advance!
Last edited by Chutney; 11-30-2009 at 05:37 PM.
Valued Forum Contributor
Re: Add values to time formatted cells
You can use the formula below for your penalty time
in cell E2 and copy down
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1