Cycling Equipment · Public discussion

OT Kind of: Dealing with minutes and hours in Excel Ride Diary?

Started by Bestest Handsander · · Last activity · 6 posts · 453 views

← Back to Cycling Equipment

This thread is locked and is currently read-only.

Thread navigation

Jump through the discussion

Go to the original post, the replies on this page, or the latest preserved contribution.

01 / Original postOT Kind of: Dealing with minutes and hours in Excel Ride Diary?Bestest Handsander · 24 Aug 2004 02 / This pagePosts 1–6Page 1 of 1 · chronological order 03 / Latest replyPost #6David Reuteler · 25 Aug 2004

Thread details

What we know about this thread

Original section
Cycling Equipment
Published
24 August 2004
Last activity
25 August 2004
Original author
Bestest Handsander
Posts
6
Discussion status
Public discussion
Total views
453
Views / 30 days
0
Topics
Single-speed and fixed-gear

The navigation and discussion metadata provide context. Posts remain in their original chronological order.

Showing posts 1–6 of 6
Posts remain in their original chronological order.

Text size
  1. Original post
    Bestest Handsander
    Archived post
    #1

    I started keeping a ride diary in Excel this year, but I've never been able
    to figure out how to get it to work with hours:minutes:seconds.

    Is there a function, format, or some other easy way to get it to work in
    base 6 instead of base 10 (I think that's what you call it). In other
    words, when adding two cells with a value of 45 minutes in each to get a
    total of 1:30? I have one area where that divides the number of hours I've
    spent on the bike for the month by the numbers of days in the month. I'm
    tired of seeing 1.25 instead of 1:15.

    Thanks

    Report
  2. J Brown
    Archived post
    #2


    Quoted message said:

    ..., when adding two cells with a value of 45 minutes in each to get a
    total of 1:30? I have one area where that divides the number of hours I've
    spent on the bike for the month by the numbers of days in the month. I'm
    tired of seeing 1.25 instead of 1:15.

    Yes, it's the proper cell format that you need for all cells
    involved in your calculations.

    Format all time cells for category "Time", type "37:30:55".

    For the time, always enter as "h:mm:ss" - e.g., for 45 minutes enter
    0:45:00.

    So I can divide a week's "8:10:00" by 7 and get 1:10:00.

    But we really should be riding rather than playing
    with stinkin' spreadsheets. 🙂

    -Joel

    I'm using Excel 2004 for mac, but I was able to do the same in Excel 98,
    but the format category/type may differ.
    I imagine the windoze version of excel works the same/similar.

    Report
  3. Email address hidden
    Archived post
    #3
    J Brown said:


    Quoted message said:

    ..., when adding two cells with a value of 45 minutes in each to get a
    total of 1:30? I have one area where that divides the number of hours I've
    spent on the bike for the month by the numbers of days in the month. I'm
    tired of seeing 1.25 instead of 1:15.

    Yes, it's the proper cell format that you need for all cells
    involved in your calculations.

    Format all time cells for category "Time", type "37:30:55".

    For the time, always enter as "h:mm:ss" - e.g., for 45 minutes enter
    0:45:00.

    So I can divide a week's "8:10:00" by 7 and get 1:10:00.

    But we really should be riding rather than playing
    with stinkin' spreadsheets. 🙂

    -Joel

    I'm using Excel 2004 for mac, but I was able to do the same in Excel 98,
    but the format category/type may differ.
    I imagine the windoze version of excel works the same/similar.

    Dear Joel,

    Hmmm . . . what a nice format. Maybe I need to consider
    upgrading my 1994 MS-DOS Lotus.

    Until then, I just add a column that totes up hours,
    minutes, and seconds as raw seconds--651,734 so far this
    year.

    Maybe this is how fixed-gear people feel when they listen to
    indexed-shifting discussions?

    Carl Fogel

    Report
  4. PeteCresswell
    Archived post
    #4

    I've got a Windows spreadsheet that does time arithmetic.

    If you want to take a look, flip me an email at
    [email hidden] and I'll send it to you.

    Report
  5. A Muzi
    Archived post
    #5
    Quoted message said:
    Quoted message said:
    Quoted message said:

    ..., when adding two cells with a value of 45 minutes


    in each to get a

    Quoted message said:
    Quoted message said:
    Quoted message said:

    total of 1:30? I have one area where that divides the number of hours I've
    spent on the bike for the month by the numbers of days in the month. I'm
    tired of seeing 1.25 instead of 1:15.

    Quoted message said:
    J Brown said:

    Yes, it's the proper cell format that you need for all cells
    involved in your calculations.
    Format all time cells for category "Time", type "37:30:55".
    For the time, always enter as "h:mm:ss" - e.g., for 45 minutes enter
    0:45:00.
    So I can divide a week's "8:10:00" by 7 and get 1:10:00.
    But we really should be riding rather than playing
    with stinkin' spreadsheets. 🙂

    Quoted message said:

    Hmmm . . . what a nice format. Maybe I need to consider
    upgrading my 1994 MS-DOS Lotus.
    Until then, I just add a column that totes up hours,
    minutes, and seconds as raw seconds--651,734 so far this
    year.
    Maybe this is how fixed-gear people feel when they listen to
    indexed-shifting discussions?

    There are valid reasons - concatenation comes to mind- to
    keep using Lotus. Graphing is better in Excel but neither is
    superior overall IMHO.

    --
    Andrew Muzi
    www.yellowjersey.org
    Open every day since 1 April, 1971

    Report
  6. David Reuteler
    Archived post
    #6
    Quoted message said:

    Maybe this is how fixed-gear people feel when they listen to
    indexed-shifting discussions?

    if by that you mean pity, then yes.
    --
    david reuteler
    [email hidden]

    Report

Keep exploring

Browse the sectionCycling Equipment Return to CyclingForumsStart at the home page Search discussionsFind another thread

Active in the last 60 minutes

Active in this thread

0 users · 0 guests ·0 bots ·0 total

No signed-in users are active right now.

No known search crawlers active right now.