+ Reply to Thread
Results 1 to 2 of 2

Trouble with time(?) function in spreadsheet

  1. #1
    Registered User
    Join Date
    06-25-2011
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Trouble with time(?) function in spreadsheet

    Sorry about the newbie question, but I've tried using the online help and can't figure it out.

    A cycle club I belong to had a time trial race. We start the stop watch at 0:00 and riders went off at 30 second intervals then do several laps of a course and then finish. We recorded lap times and finish times all from the reference starting time (00:00).

    I want to make a spreadsheet that I can enter each start time in minutes and seconds starting at 00:00. I imagine this would be column 1 and go in sequence 00:00, 00:30, 1:00 etc etc. But I don't seem to be able to set the format that shows the number as a time that isn't the time of day. When I type in 00:00 excel sees it as 12:00am.
    From there I want to be able to enter all the data from the laps and finish times in seperate columns then use simple formulas to subtract the recorded time from the start sequence (30 second intervals) to get the actual lap times and finish time.

    Every thing I do tends to become a problem because of excel seeing the time as a time of day rather than a elapsed time from the 00:00 start time.

    Help please.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Trouble with time(?) function in spreadsheet

    Hi toppity and welcome to the forum,

    I'm imagining myself sitting at the start line and every time a bike rider crosses the line I need to record their number and the time. I'd rather not need to look at the worksheet and find their number and click on which lap it is. This is how I've structured the example. Each crossing of a rider records their number and their time in Columns A and B.

    I then created a helping column that shows which time they crossed in Column C.
    I used this number to do the calculations in Columns D to G.

    I hope the attached helps to show how I think you could do this problem.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1